Re: Connections - Postgres 9.2
| От | Venkata Balaji N |
|---|---|
| Тема | Re: Connections - Postgres 9.2 |
| Дата | |
| Msg-id | CAEyp7J-TJWyMKX_3ZEGzSX+cfq+mORnDOiADQyQw0Q=6sAKGDw@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Connections - Postgres 9.2 (Lucas Possamai <drum.lucas@gmail.com>) |
| Ответы |
Re: Connections - Postgres 9.2
|
| Список | pgsql-general |
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
В списке pgsql-general по дате отправления: