Обсуждение: BUG #14453: Growing file descriptors on IDLE connections

Поиск
Список
Период
Сортировка

BUG #14453: Growing file descriptors on IDLE connections

От
akshay.ballarpure@tcs.com
Дата:
VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJz
aXRlOgoKQnVnIHJlZmVyZW5jZTogICAgICAxNDQ1MwpMb2dnZWQgYnk6ICAg
ICAgICAgIEFrc2hheSBCCkVtYWlsIGFkZHJlc3M6ICAgICAgYWtzaGF5LmJh
bGxhcnB1cmVAdGNzLmNvbQpQb3N0Z3JlU1FMIHZlcnNpb246IFVuc3VwcG9y
dGVkL1Vua25vd24KT3BlcmF0aW5nIHN5c3RlbTogICBSSEVMCkRlc2NyaXB0
aW9uOiAgICAgICAgCgpIaSwNCklzIHRoZXJlIGFueSB3YXkgdG8gY2xlYW4g
dXAgaWRsZSBjb25uZWN0aW9ucyB3aGljaCBhcmUgY29uc3VtaW5nIGEgbGFy
Z2UKbnVtYmVyIG9mIGZpbGUgZGVzY3JpcHRvcnMgPyBEb2VzIGl0IGhhdmUg
YW55IGltcGFjdCBvbiBwc3FsIHNlcnZlcgpwZXJmb3JtYW5jZSA/DQoNClty
b290QG1zLWVzbW9uIGNsb3VkLXVzZXJdIyBwcyAtZWFmIHwgZ3JlcCBwb3N0
Z3Jlcw0KcG9zdGdyZXMgIDI4MDkgICAgIDEgIDAgRGVjMDYgPyAgICAgICAg
MDA6MDA6MDQgL3Vzci9iaW4vcG9zdG1hc3RlciAtcCA1NDMyCi1EIC92YXIv
ZXJpY3Nzb24vZXNtLWRhdGEvcG9zdGdyZXNxbC1kYXRhDQpwb3N0Z3JlcyAg
MjgxMSAgMjgwOSAgMCBEZWMwNiA/ICAgICAgICAwMDowMDowOSBwb3N0Z3Jl
czogbG9nZ2VyIHByb2Nlc3MgICAgCiAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICANCnBvc3RncmVzICAyODEzICAyODA5ICAwIERl
YzA2ID8gICAgICAgIDAwOjAxOjEwIHBvc3RncmVzOiB3cml0ZXIgcHJvY2Vz
cyAgICAKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
IA0KcG9zdGdyZXMgIDI4MTQgIDI4MDkgIDAgRGVjMDYgPyAgICAgICAgMDA6
MDA6NDggcG9zdGdyZXM6IHdhbCB3cml0ZXIgcHJvY2VzcwogICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgDQpwb3N0Z3JlcyAgMjgx
NSAgMjgwOSAgMCBEZWMwNiA/ICAgICAgICAwMDowMDoxNSBwb3N0Z3Jlczog
YXV0b3ZhY3V1bQpsYXVuY2hlciBwcm9jZXNzICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICANCnBvc3RncmVzICAyODE2ICAyODA5ICAwIERlYzA2
ID8gICAgICAgIDAwOjAwOjE3IHBvc3RncmVzOiBzdGF0cyBjb2xsZWN0b3IK
cHJvY2VzcyAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIA0K
cG9zdGdyZXMgMTY5MzQgIDI4MDkgIDAgMTA6MzUgPyAgICAgICAgMDA6MDA6
MDIgcG9zdGdyZXM6IHJocWFkbWluIHJocQoxMjcuMC4wLjEoNTU2NzYpIGlk
bGUgICAgICAgICAgICAgICAgICAgICAgICAgDQpwb3N0Z3JlcyAxNzMxNSAg
MjgwOSAgMCAxMDozNyA/ICAgICAgICAwMDowMDowMCBwb3N0Z3Jlczogcmhx
YWRtaW4gcmhxCjEyNy4wLjAuMSg1NTcwOSkgaWRsZSAgICAgICAgICAgICAg
ICAgICAgICAgICANCnBvc3RncmVzIDE3MzE4ICAyODA5ICAwIDEwOjM3ID8g
ICAgICAgIDAwOjAwOjAwIHBvc3RncmVzOiByaHFhZG1pbiByaHEKMTI3LjAu
MC4xKDU1NzEwKSBpZGxlICAgICAgICAgICAgICAgICAgICAgICAgIA0KcG9z
dGdyZXMgMTczMzggIDI4MDkgIDAgMTA6MzcgPyAgICAgICAgMDA6MDA6MDAg
cG9zdGdyZXM6IHJocWFkbWluIHJocQoxMjcuMC4wLjEoNTU3MTYpIGlkbGUg
ICAgICAgICAgICAgICAgICAgICAgICAgDQpwb3N0Z3JlcyAxNzMzOSAgMjgw
OSAgMCAxMDozNyA/ICAgICAgICAwMDowMDowMCBwb3N0Z3JlczogcmhxYWRt
aW4gcmhxCjEyNy4wLjAuMSg1NTcxNykgaWRsZSAgICAgICAgICAgICAgICAg
ICAgICAgICANCnBvc3RncmVzIDE3MzQwICAyODA5ICAwIDEwOjM3ID8gICAg
ICAgIDAwOjAwOjAwIHBvc3RncmVzOiByaHFhZG1pbiByaHEKMTI3LjAuMC4x
KDU1NzE4KSBpZGxlICAgICAgICAgICAgICAgICAgICAgICAgIA0KcG9zdGdy
ZXMgMTczNDEgIDI4MDkgIDAgMTA6MzcgPyAgICAgICAgMDA6MDA6MDAgcG9z
dGdyZXM6IHJocWFkbWluIHJocQoxMjcuMC4wLjEoNTU3MTkpIGlkbGUgICAg
ICAgICAgICAgICAgICAgICAgICAgDQpwb3N0Z3JlcyAxNzUyNyAgMjgwOSAg
MCAxMDozNyA/ICAgICAgICAwMDowMDowMCBwb3N0Z3JlczogcmhxYWRtaW4g
cmhxCjEyNy4wLjAuMSg1NTcyMCkgaWRsZSAgICAgICAgICAgICAgICAgICAg
ICAgICANCnBvc3RncmVzIDE3NTI4ICAyODA5ICAwIDEwOjM3ID8gICAgICAg
IDAwOjAwOjAwIHBvc3RncmVzOiByaHFhZG1pbiByaHEKMTI3LjAuMC4xKDU1
NzIxKSBpZGxlICAgICAgICAgICAgICAgICAgICAgICAgIA0KcG9zdGdyZXMg
MTc1MzAgIDI4MDkgIDAgMTA6MzcgPyAgICAgICAgMDA6MDA6MDAgcG9zdGdy
ZXM6IHJocWFkbWluIHJocQoxMjcuMC4wLjEoNTU3MjIpIGlkbGUgICAgICAg
ICAgICAgICAgICAgICAgICAgDQpwb3N0Z3JlcyAxNzUzNCAgMjgwOSAgMCAx
MDozNyA/ICAgICAgICAwMDowMDowMCBwb3N0Z3JlczogcmhxYWRtaW4gcmhx
CjEyNy4wLjAuMSg1NTcyMykgaWRsZSAgICAgICAgICAgICAgICAgICAgICAg
ICANCnBvc3RncmVzIDE4MDk1ICAyODA5ICAwIDEwOjQ0ID8gICAgICAgIDAw
OjAwOjAwIHBvc3RncmVzOiByaHFhZG1pbiByaHEKMTI3LjAuMC4xKDU1Nzc5
KSBpZGxlICAgICAgICAgICAgICAgICAgICAgICAgIA0KcG9zdGdyZXMgMTg0
MjYgIDI4MDkgIDAgMTA6NDcgPyAgICAgICAgMDA6MDA6MDAgcG9zdGdyZXM6
IHJocWFkbWluIHJocQpbbG9jYWxdIGlkbGUgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgDQpwb3N0Z3JlcyAxOTQ1MiAgMjgwOSAgMCAxMDo1
MiA/ICAgICAgICAwMDowMDowMCBwb3N0Z3JlczogcmhxYWRtaW4gcmhxClts
b2NhbF0gaWRsZSAgICANCg0KW3Jvb3RAbXMtZXNtb24gY2xvdWQtdXNlcl0j
IGxzb2YgLXAgMjgxMyB8IHdjIC1sDQo1MQ0KW3Jvb3RAbXMtZXNtb24gY2xv
dWQtdXNlcl0jIGxzb2YgLXAgMjgxNCB8IHdjIC1sDQo0NA0KW3Jvb3RAbXMt
ZXNtb24gY2xvdWQtdXNlcl0jIGxzb2YgLXAgMjgxNSB8IHdjIC1sDQo0Mw0K
W3Jvb3RAbXMtZXNtb24gY2xvdWQtdXNlcl0jIGxzb2YgLXAgMjgxNiB8IHdj
IC1sDQo0Mg0KW3Jvb3RAbXMtZXNtb24gY2xvdWQtdXNlcl0jIGxzb2YgLXAg
MjgwOSB8IHdjIC1sDQo0Nw0KW3Jvb3RAbXMtZXNtb24gY2xvdWQtdXNlcl0j
IGxzb2YgLXAgMjgxMSB8IHdjIC1sDQo0Mw0KDQpiZWxvdyBhcmUgdGhlIGNv
dW50cyBvbiBpZGxlIGNvbm5lY3Rpb25zIFBJRA0KW3Jvb3RAbXMtZXNtb24g
Y2xvdWQtdXNlcl0jIGxzb2YgLXAgMTY5MzQgfCB3YyAtbA0KMjIwDQpbcm9v
dEBtcy1lc21vbiBjbG91ZC11c2VyXSMgbHNvZiAtcCAxNzMxNSB8IHdjIC1s
DQo4MA0KW3Jvb3RAbXMtZXNtb24gY2xvdWQtdXNlcl0jIGxzb2YgLXAgMTcz
MTggfCB3YyAtbA0KNzkNCltyb290QG1zLWVzbW9uIGNsb3VkLXVzZXJdIyBs
c29mIC1wIDE3MzM4IHwgd2MgLWwNCjE0MA0KW3Jvb3RAbXMtZXNtb24gY2xv
dWQtdXNlcl0jIGxzb2YgLXAgMTczMzkgfCB3YyAtbA0KMTUwDQpbcm9vdEBt
cy1lc21vbiBjbG91ZC11c2VyXSMgbHNvZiAtcCAxNzM0MCB8IHdjIC1sDQox
NDgNCgoK

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

От
Stephen Frost
Дата:
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