Re: IDLE queries taking up space

Поиск
Список
Период
Сортировка
От Merlin Moncure
Тема Re: IDLE queries taking up space
Дата
Msg-id CAHyXU0xoCd0Tkd6mz40NTAeHDhkyRovvGP5hDbh_R90qG-v6MA@mail.gmail.com
обсуждение исходный текст
Ответ на IDLE queries taking up space  (JD Wong <jdmswong@gmail.com>)
Список pgsql-general
On Tue, Aug 30, 2011 at 11:03 AM, JD Wong <jdmswong@gmail.com> wrote:
> Hi,
> When I run select datname, procpid, current_query from pg_stat_activity; I
> get 26 rows of <IDLE> queries.  How can I set postgres to qutomatically
> close connections that have finished their queries and now sit idle?

you don't. this should be managed from the client, or you can use a
connection pool.

merlin

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

Предыдущее
От: Merlin Moncure
Дата:
Сообщение: Re: heavy swapping, not sure why
Следующее
От: Tom Lane
Дата:
Сообщение: Re: heavy swapping, not sure why