[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: problems with set_config, work_mem, maintenance_work_mem, and sorting

To: Jon Nelson <jnelson+pgsql@xxxxxxxxxxx>
Subject: Re: problems with set_config, work_mem, maintenance_work_mem, and sorting
From: Claudio Freire <klaussfreire@xxxxxxxxx>
Date: Tue, 28 Feb 2012 20:43:37 -0300
Authentication-results: mr.google.com; spf=pass (google.com: domain of klaussfreire@xxxxxxxxx designates 10.152.135.148 as permitted sender) smtp.mail=klaussfreire@xxxxxxxxx; dkim=pass header.i=klaussfreire@xxxxxxxxx
Cc: Tom Lane <tgl@xxxxxxxxxxxxx>, pgsql-performance@xxxxxxxxxxxxxx
In-reply-to: <CAKuK5J2FFqWrBOUJ3KuGC2wKUpawXRKij=oJd5TLWjf8HvjwPg@mail.gmail.com>
References: <CAKuK5J22ZTaVrVSPUerPA2_Fe-+udtOFWxSoOjFi9r9=5gyZgw@mail.gmail.com> <9466.1330457283@sss.pgh.pa.us> <CAKuK5J2rHEM_GCoCTPyw3ajn3yvg3QFX6apSiYbvJULDt_TGyg@mail.gmail.com> <10857.1330462314@sss.pgh.pa.us> <CAKuK5J0+Rpt3rwQJLCrzgBj-ShJWhVjxSAPS8tJSLOYGB4QA=Q@mail.gmail.com> <27623.1330466083@sss.pgh.pa.us> <CAGTBQpZ8m2gKS36JGKANBzb39hjynSJ3w9mTu9QetdmRzi5Ocw@mail.gmail.com> <CAKuK5J2FFqWrBOUJ3KuGC2wKUpawXRKij=oJd5TLWjf8HvjwPg@mail.gmail.com>

On Tue, Feb 28, 2012 at 8:00 PM, Jon Nelson <jnelson+pgsql@xxxxxxxxxxx> wrote:
> I cranked the logging /all/ the way up and isolated the server.
> I suspect that your theory is correct.

Another option, depending on your SQLA version, when connections are
sent back to the pool, I seem to remember they were reset. That would
also reset the work_mem, you'd still see the same pid on PG logs, but
it's not the same session.

-- 
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

Follow-Ups:
- Re: problems with set_config, work_mem, maintenance_work_mem, and sorting
  - From: Ants Aasma

References:
- problems with set_config, work_mem, maintenance_work_mem, and sorting
  - From: Jon Nelson
- Re: problems with set_config, work_mem, maintenance_work_mem, and sorting
  - From: Tom Lane
- Re: problems with set_config, work_mem, maintenance_work_mem, and sorting
  - From: Jon Nelson
- Re: problems with set_config, work_mem, maintenance_work_mem, and sorting
  - From: Tom Lane
- Re: problems with set_config, work_mem, maintenance_work_mem, and sorting
  - From: Jon Nelson
- Re: problems with set_config, work_mem, maintenance_work_mem, and sorting
  - From: Tom Lane
- Re: problems with set_config, work_mem, maintenance_work_mem, and sorting
  - From: Claudio Freire
- Re: problems with set_config, work_mem, maintenance_work_mem, and sorting
  - From: Jon Nelson

Prev by Date: Re: problems with set_config, work_mem, maintenance_work_mem, and sorting
Next by Date: Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory?
Previous by thread: Re: problems with set_config, work_mem, maintenance_work_mem, and sorting
Next by thread: Re: problems with set_config, work_mem, maintenance_work_mem, and sorting
Index(es):
- Date
- Thread

[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Home] [Yosemite]