From: | akshay(dot)ballarpure(at)tcs(dot)com |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #14453: Growing file descriptors on IDLE connections |
Date: | 2016-12-07 11:06:18 |
Message-ID: | 20161207110618.31169.97238@wrigleys.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 14453
Logged by: Akshay B
Email address: akshay(dot)ballarpure(at)tcs(dot)com
PostgreSQL version: Unsupported/Unknown
Operating system: RHEL
Description:
Hi,
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 ?
[root(at)ms-esmon cloud-user]# ps -eaf | grep postgres
postgres 2809 1 0 Dec06 ? 00:00:04 /usr/bin/postmaster -p 5432
-D /var/ericsson/esm-data/postgresql-data
postgres 2811 2809 0 Dec06 ? 00:00:09 postgres: logger process
postgres 2813 2809 0 Dec06 ? 00:01:10 postgres: writer process
postgres 2814 2809 0 Dec06 ? 00:00:48 postgres: wal writer process
postgres 2815 2809 0 Dec06 ? 00:00:15 postgres: autovacuum
launcher process
postgres 2816 2809 0 Dec06 ? 00:00:17 postgres: stats collector
process
postgres 16934 2809 0 10:35 ? 00:00:02 postgres: rhqadmin rhq
127.0.0.1(55676) idle
postgres 17315 2809 0 10:37 ? 00:00:00 postgres: rhqadmin rhq
127.0.0.1(55709) idle
postgres 17318 2809 0 10:37 ? 00:00:00 postgres: rhqadmin rhq
127.0.0.1(55710) idle
postgres 17338 2809 0 10:37 ? 00:00:00 postgres: rhqadmin rhq
127.0.0.1(55716) idle
postgres 17339 2809 0 10:37 ? 00:00:00 postgres: rhqadmin rhq
127.0.0.1(55717) idle
postgres 17340 2809 0 10:37 ? 00:00:00 postgres: rhqadmin rhq
127.0.0.1(55718) idle
postgres 17341 2809 0 10:37 ? 00:00:00 postgres: rhqadmin rhq
127.0.0.1(55719) idle
postgres 17527 2809 0 10:37 ? 00:00:00 postgres: rhqadmin rhq
127.0.0.1(55720) idle
postgres 17528 2809 0 10:37 ? 00:00:00 postgres: rhqadmin rhq
127.0.0.1(55721) idle
postgres 17530 2809 0 10:37 ? 00:00:00 postgres: rhqadmin rhq
127.0.0.1(55722) idle
postgres 17534 2809 0 10:37 ? 00:00:00 postgres: rhqadmin rhq
127.0.0.1(55723) idle
postgres 18095 2809 0 10:44 ? 00:00:00 postgres: rhqadmin rhq
127.0.0.1(55779) idle
postgres 18426 2809 0 10:47 ? 00:00:00 postgres: rhqadmin rhq
[local] idle
postgres 19452 2809 0 10:52 ? 00:00:00 postgres: rhqadmin rhq
[local] idle
[root(at)ms-esmon cloud-user]# lsof -p 2813 | wc -l
51
[root(at)ms-esmon cloud-user]# lsof -p 2814 | wc -l
44
[root(at)ms-esmon cloud-user]# lsof -p 2815 | wc -l
43
[root(at)ms-esmon cloud-user]# lsof -p 2816 | wc -l
42
[root(at)ms-esmon cloud-user]# lsof -p 2809 | wc -l
47
[root(at)ms-esmon cloud-user]# lsof -p 2811 | wc -l
43
below are the counts on idle connections PID
[root(at)ms-esmon cloud-user]# lsof -p 16934 | wc -l
220
[root(at)ms-esmon cloud-user]# lsof -p 17315 | wc -l
80
[root(at)ms-esmon cloud-user]# lsof -p 17318 | wc -l
79
[root(at)ms-esmon cloud-user]# lsof -p 17338 | wc -l
140
[root(at)ms-esmon cloud-user]# lsof -p 17339 | wc -l
150
[root(at)ms-esmon cloud-user]# lsof -p 17340 | wc -l
148
From | Date | Subject | |
---|---|---|---|
Next Message | Stephen Frost | 2016-12-07 14:15:26 | Re: BUG #14453: Growing file descriptors on IDLE connections |
Previous Message | John R Pierce | 2016-12-07 03:56:16 | Re: BUG #14452: Unexpected transaction behaviour |