| From: | Stephen Frost <sfrost(at)snowman(dot)net> |
|---|---|
| To: | akshay(dot)ballarpure(at)tcs(dot)com |
| Cc: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: BUG #14453: Growing file descriptors on IDLE connections |
| Date: | 2016-12-07 14:15:26 |
| Message-ID: | 20161207141525.GW23417@tamriel.snowman.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
Greetings,
* akshay(dot)ballarpure(at)tcs(dot)com (akshay(dot)ballarpure(at)tcs(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | xammett | 2016-12-07 15:27:10 | BUG #14454: xmlelement doesn't support encoding |
| Previous Message | akshay.ballarpure | 2016-12-07 11:06:18 | BUG #14453: Growing file descriptors on IDLE connections |