Re: Connections - Postgres 9.2

Поиск
Список
Период
Сортировка
От Lucas Possamai
Тема Re: Connections - Postgres 9.2
Дата
Msg-id CAE_gQfV62Yde34ot1GdenBtzJtpEffWkTQMKvaK3Z6gx4+VBoA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Connections - Postgres 9.2  (Venkata Balaji N <nag1010@gmail.com>)
Список pgsql-general


On 17 May 2016 at 08:56, Venkata Balaji N <nag1010@gmail.com> wrote:

On Tue, May 17, 2016 at 6:28 AM, Lucas Possamai <drum.lucas@gmail.com> wrote:
hmm.. thanks for all the answers guys...


One more question: Those IDLE connections.. are using the server's resources?
To solve that problem I would need a Pool connection, right?

Would the pool connection solve that IDLE connections? But more important than that, are the IDLE connections using the machine's resources ?

Yes. There is no straight way to terminate the IDLE connections from the database end. You would need a connection pooler like pgBouncer which can help you terminate IDLE connections after a certain time.

It would be much better if your Application can terminate connections to the database.

Regards,
Venkata B N

Fujitsu Australia




Ok awesome.. thanks a lot!

Lucas

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

Предыдущее
От: John R Pierce
Дата:
Сообщение: Re: Connections - Postgres 9.2
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Connections - Postgres 9.2