Обсуждение: BUG #14453: Growing file descriptors on IDLE connections
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
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