Re: BUG #14453: Growing file descriptors on IDLE connections

Поиск
Список
Период
Сортировка
От Stephen Frost
Тема Re: BUG #14453: Growing file descriptors on IDLE connections
Дата
Msg-id 20161207141525.GW23417@tamriel.snowman.net
обсуждение исходный текст
Ответ на BUG #14453: Growing file descriptors on IDLE connections  (akshay.ballarpure@tcs.com)
Список pgsql-bugs
Greetings,

* akshay.ballarpure@tcs.com (akshay.ballarpure@tcs.com) wrote:
> The following bug has been logged on the website:

THis is not a bug.

> Is there any way to clean up idle connections which are consuming a large
> number of file descriptors ? Does it have any impact on psql server
> performance ?

Having lots of idle connections around can impact performance in some
instances.  PostrgeSQL intentionally caches the file descriptors of open
files to avoid the overhead of opening them again but that generally
isn't a performance issue.

I would suggest you look into a connection pooler (eg: pgbouncer) to
avoid having lots of idle connections to the database.

Thanks!

Stephen

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

Предыдущее
От: akshay.ballarpure@tcs.com
Дата:
Сообщение: BUG #14453: Growing file descriptors on IDLE connections
Следующее
От: xammett@gmail.com
Дата:
Сообщение: BUG #14454: xmlelement doesn't support encoding