Re: BUG #14453: Growing file descriptors on IDLE connections - Mailing list pgsql-bugs

From Stephen Frost
Subject Re: BUG #14453: Growing file descriptors on IDLE connections
Date
Msg-id 20161207141525.GW23417@tamriel.snowman.net
Whole thread Raw
In response to BUG #14453: Growing file descriptors on IDLE connections  (akshay.ballarpure@tcs.com)
List 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 by date:

Previous
From: akshay.ballarpure@tcs.com
Date:
Subject: BUG #14453: Growing file descriptors on IDLE connections
Next
From: xammett@gmail.com
Date:
Subject: BUG #14454: xmlelement doesn't support encoding