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

Поиск
Список
Период
Сортировка
От Claudio Freire
Тема Re: problems with set_config, work_mem, maintenance_work_mem, and sorting
Дата
Msg-id CAGTBQpbok6o8Z0vBVf4kDaAqOdSowbRnY=K5DR2yxD7n+PX6zA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: problems with set_config, work_mem, maintenance_work_mem, and sorting  (Jon Nelson <jnelson+pgsql@jamponi.net>)
Ответы Re: problems with set_config, work_mem, maintenance_work_mem, and sorting
Список pgsql-performance
Дерево обсуждения 
On Tue, Feb 28, 2012 at 8:00 PM, Jon Nelson <jnelson+pgsql@jamponi.net> 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.

В списке pgsql-performance по дате отправления:

Предыдущее
От: Jon Nelson
Дата:
Сообщение: Re: problems with set_config, work_mem, maintenance_work_mem, and sorting
Следующее
От: Stefan Keller
Дата:
Сообщение: Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory?