BUG #14234: PostgreSQL consuming large amount of memory for persistent connection
| От | digoal@126.com |
|---|---|
| Тема | BUG #14234: PostgreSQL consuming large amount of memory for persistent connection |
| Дата | |
| Msg-id | 20160708012833.1419.89062@wrigleys.postgresql.org обсуждение исходный текст |
| Ответы |
Re: BUG #14234: PostgreSQL consuming large amount of memory for persistent connection
(Tom Lane <tgl@sss.pgh.pa.us>)
|
| Список | pgsql-bugs |
VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJz aXRlOgoKQnVnIHJlZmVyZW5jZTogICAgICAxNDIzNApMb2dnZWQgYnk6ICAg ICAgICAgIFpob3UgRGlnb2FsCkVtYWlsIGFkZHJlc3M6ICAgICAgZGlnb2Fs QDEyNi5jb20KUG9zdGdyZVNRTCB2ZXJzaW9uOiA5LjUuMwpPcGVyYXRpbmcg c3lzdGVtOiAgIENlbnRPUyA2LnggeDY0CkRlc2NyaXB0aW9uOiAgICAgICAg Cgp0ZXN0IGNhc2UgOiANClBvc3RncmVTUUwgY29uZiA6IA0KbGlzdGVuX2Fk ZHJlc3NlcyA9ICcwLjAuMC4wJyAgICAgICAgICAgICMgd2hhdCBJUCBhZGRy ZXNzKGVzKSB0byBsaXN0ZW4Kb247DQpwb3J0ID0gMTkyMSAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgIyAoY2hhbmdlIHJlcXVpcmVzIHJlc3RhcnQp DQptYXhfY29ubmVjdGlvbnMgPSAxMDAgICAgICAgICAgICAgICAgICAgIyAo Y2hhbmdlIHJlcXVpcmVzIHJlc3RhcnQpDQpzdXBlcnVzZXJfcmVzZXJ2ZWRf Y29ubmVjdGlvbnMgPSAzICAgICAgIyAoY2hhbmdlIHJlcXVpcmVzIHJlc3Rh cnQpDQp1bml4X3NvY2tldF9kaXJlY3RvcmllcyA9ICcuJyAgICMgY29tbWEt c2VwYXJhdGVkIGxpc3Qgb2YgZGlyZWN0b3JpZXMNCnRjcF9rZWVwYWxpdmVz X2lkbGUgPSAxMCAgICAgICAgICAgICAgICAjIFRDUF9LRUVQSURMRSwgaW4g c2Vjb25kczsNCnRjcF9rZWVwYWxpdmVzX2ludGVydmFsID0gMTAgICAgICAg ICAgICAjIFRDUF9LRUVQSU5UVkwsIGluIHNlY29uZHM7DQp0Y3Bfa2VlcGFs aXZlc19jb3VudCA9IDYwICAgICAgICAgICAgICAgIyBUQ1BfS0VFUENOVDsN CnNoYXJlZF9idWZmZXJzID0gNEdCICAgICAgICAgICAgICAgICAgICAjIG1p biAxMjhrQg0KZHluYW1pY19zaGFyZWRfbWVtb3J5X3R5cGUgPSBwb3NpeCAg ICAgICMgdGhlIGRlZmF1bHQgaXMgdGhlIGZpcnN0IG9wdGlvbg0Kd2FsX2xl dmVsID0gaG90X3N0YW5kYnkgICAgICAgICAgICAgICAgICMgbWluaW1hbCwg YXJjaGl2ZSwgaG90X3N0YW5kYnksIG9yCmxvZ2ljYWwNCmZzeW5jID0gb2Zm ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAjIHR1cm5zIGZvcmNlZCBz eW5jaHJvbml6YXRpb24gb24gb3IKb2ZmDQpzeW5jaHJvbm91c19jb21taXQg PSBvZmYgICAgICAgICAgICAgICAgIyBzeW5jaHJvbml6YXRpb24gbGV2ZWw7 DQpmdWxsX3BhZ2Vfd3JpdGVzID0gb2ZmICAgICAgICAgICAgICAgICAgIyBy ZWNvdmVyIGZyb20gcGFydGlhbCBwYWdlIHdyaXRlcw0Kd2FsX2J1ZmZlcnMg PSAxOTAwTUIgICAgICAgICAgICAgICAgICAgICMgbWluIDMya0IsIC0xIHNl dHMgYmFzZWQgb24Kc2hhcmVkX2J1ZmZlcnMNCndhbF93cml0ZXJfZGVsYXkg PSAxMG1zICAgICAgICAgIyAxLTEwMDAwIG1pbGxpc2Vjb25kcw0KbWF4X3dh bF9zZW5kZXJzID0gMTAgICAgICAgICAgICAjIG1heCBudW1iZXIgb2Ygd2Fs c2VuZGVyIHByb2Nlc3Nlcw0Kd2FsX2tlZXBfc2VnbWVudHMgPSAxMDAgICAg ICAgICAjIGluIGxvZ2ZpbGUgc2VnbWVudHMsIDE2TUIgZWFjaDsgMApkaXNh Ymxlcw0Kc3luY2hyb25vdXNfc3RhbmRieV9uYW1lcyA9ICcqJyAjIHN0YW5k Ynkgc2VydmVycyB0aGF0IHByb3ZpZGUgc3luYyByZXANCmhvdF9zdGFuZGJ5 ID0gb24gICAgICAgICAgICAgICAgICAgICAgICAjICJvbiIgYWxsb3dzIHF1 ZXJpZXMgZHVyaW5nCnJlY292ZXJ5DQp3YWxfcmVjZWl2ZXJfc3RhdHVzX2lu dGVydmFsID0gMXMgICAgICAgIyBzZW5kIHJlcGxpZXMgYXQgbGVhc3QgdGhp cyBvZnRlbg0KaG90X3N0YW5kYnlfZmVlZGJhY2sgPSBvbiAgICAgICAgICAg ICAgICMgc2VuZCBpbmZvIGZyb20gc3RhbmRieSB0bwpwcmV2ZW50DQp3YWxf cmV0cmlldmVfcmV0cnlfaW50ZXJ2YWwgPSAxcyAgICAgICAgIyB0aW1lIHRv IHdhaXQgYmVmb3JlIHJldHJ5aW5nIHRvDQpsb2dfZGVzdGluYXRpb24gPSAn Y3N2bG9nJyAgICAgICAgICAgICAgIyBWYWxpZCB2YWx1ZXMgYXJlIGNvbWJp bmF0aW9ucyBvZg0KbG9nZ2luZ19jb2xsZWN0b3IgPSBvbiAgICAgICAgICAj IEVuYWJsZSBjYXB0dXJpbmcgb2Ygc3RkZXJyIGFuZCBjc3Zsb2cNCmxvZ190 cnVuY2F0ZV9vbl9yb3RhdGlvbiA9IG9uICAgICAgICAgICAjIElmIG9uLCBh biBleGlzdGluZyBsb2cgZmlsZSB3aXRoCnRoZQ0KbG9nX3RpbWV6b25lID0g J1BSQycNCmRhdGVzdHlsZSA9ICdpc28sIG1keScNCnRpbWV6b25lID0gJ1BS QycNCmxjX21lc3NhZ2VzID0gJ0MnICAgICAgICAgICAgICAgICAgICAgICAj IGxvY2FsZSBmb3Igc3lzdGVtIGVycm9yIG1lc3NhZ2UNCmxjX21vbmV0YXJ5 ID0gJ0MnICAgICAgICAgICAgICAgICAgICAgICAjIGxvY2FsZSBmb3IgbW9u ZXRhcnkgZm9ybWF0dGluZw0KbGNfbnVtZXJpYyA9ICdDJyAgICAgICAgICAg ICAgICAgICAgICAgICMgbG9jYWxlIGZvciBudW1iZXIgZm9ybWF0dGluZw0K bGNfdGltZSA9ICdDJyAgICAgICAgICAgICAgICAgICAgICAgICAgICMgbG9j YWxlIGZvciB0aW1lIGZvcm1hdHRpbmcNCmRlZmF1bHRfdGV4dF9zZWFyY2hf Y29uZmlnID0gJ3BnX2NhdGFsb2cuZW5nbGlzaCcNCm1heF9sb2Nrc19wZXJf dHJhbnNhY3Rpb24gPSAxMDAwMCAgICAgICAgICAgICAgICMgbWluIDEwDQph bGxvd19zeXN0ZW1fdGFibGVfbW9kcyA9b2ZmDQpsb2dfc3RhdGVtZW50PW5v bmUNCg0KZnVuY3Rpb25zIDogDQotLSBNVERCX2Rlc3Ryb3kNCmNyZWF0ZSBv ciByZXBsYWNlIGZ1bmN0aW9uIE1UREJfZGVzdHJveSAoc2NoZW1hTmFtZVBy ZWZpeCB2YXJjaGFyKDEwMCkpDQpyZXR1cm5zIGludCBhcyAkJA0KZGVjbGFy ZQ0KICAgY3VyczEgY3Vyc29yKHByZWZpeCB2YXJjaGFyKSBpcyBzZWxlY3Qg c2NoZW1hX25hbWUgZnJvbQppbmZvcm1hdGlvbl9zY2hlbWEuc2NoZW1hdGEg d2hlcmUgc2NoZW1hX25hbWUgbGlrZSBwcmVmaXggfHwgJyUnOw0KICAgc2No ZW1hTmFtZSB2YXJjaGFyKDEwMCk7DQogICBjb3VudCBpbnRlZ2VyOw0KYmVn aW4NCiAgIGNvdW50IDo9IDA7DQogICBvcGVuIGN1cnMxKHNjaGVtYU5hbWVQ cmVmaXgpOw0KICAgbG9vcA0KICAgICAgZmV0Y2ggY3VyczEgaW50byBzY2hl bWFOYW1lOw0KICAgICAgaWYgbm90IGZvdW5kIHRoZW4gZXhpdDsgZW5kIGlm OyAgICAgICAgICAgDQogICAgICBjb3VudCA6PSBjb3VudCArIDE7DQogICAg ICBleGVjdXRlICdkcm9wIHNjaGVtYSAnIHx8IHNjaGVtYU5hbWUgfHwgJyBj YXNjYWRlOyc7DQogICBlbmQgbG9vcDsgIA0KICAgY2xvc2UgY3VyczE7DQog ICByZXR1cm4gY291bnQ7DQplbmQgJCQgbGFuZ3VhZ2UgcGxwZ3NxbDsNCg0K LS0gTVREQl9Jbml0aWFsaXplDQpjcmVhdGUgb3IgcmVwbGFjZSBmdW5jdGlv biBNVERCX0luaXRpYWxpemUgKHNjaGVtYU5hbWVQcmVmaXggdmFyY2hhcigx MDApLApudW1iZXJPZlNjaGVtYXMgaW50ZWdlciwgbnVtYmVyT2ZUYWJsZXNQ ZXJTY2hlbWEgaW50ZWdlciwKY3JlYXRlVmlld0ZvckVhY2hUYWJsZSBib29s ZWFuKQ0KcmV0dXJucyBpbnRlZ2VyIGFzICQkDQpkZWNsYXJlICAgDQogICBj dXJyZW50U2NoZW1hSWQgaW50ZWdlcjsNCiAgIGN1cnJlbnRUYWJsZUlkIGlu dGVnZXI7DQogICBjdXJyZW50U2NoZW1hTmFtZSB2YXJjaGFyKDEwMCk7DQog ICBjdXJyZW50VGFibGVOYW1lIHZhcmNoYXIoMTAwKTsNCiAgIGN1cnJlbnRW aWV3TmFtZSB2YXJjaGFyKDEwMCk7DQogICBjb3VudCBpbnRlZ2VyOw0KYmVn aW4NCiAgIC0tIGNsZWFyDQogICBwZXJmb3JtIE1UREJfRGVzdHJveShzY2hl bWFOYW1lUHJlZml4KTsNCg0KICAgY291bnQgOj0gMDsNCiAgIGN1cnJlbnRT Y2hlbWFJZCA6PSAxOw0KICAgbG9vcA0KICAgICAgY3VycmVudFNjaGVtYU5h bWUgOj0gc2NoZW1hTmFtZVByZWZpeCB8fApsdHJpbShjdXJyZW50U2NoZW1h SWQ6OnZhcmNoYXIoMTApKTsNCiAgICAgIGV4ZWN1dGUgJ2NyZWF0ZSBzY2hl bWEgJyB8fCBjdXJyZW50U2NoZW1hTmFtZTsNCg0KICAgICAgY3VycmVudFRh YmxlSWQgOj0gMTsNCiAgICAgIGxvb3ANCiAgICAgICAgIGN1cnJlbnRUYWJs ZU5hbWUgOj0gY3VycmVudFNjaGVtYU5hbWUgfHwgJy4nIHx8ICd0YWJsZScg fHwKbHRyaW0oY3VycmVudFRhYmxlSWQ6OnZhcmNoYXIoMTApKTsNCiAgICAg ICAgIGV4ZWN1dGUgJ2NyZWF0ZSB0YWJsZSAnIHx8IGN1cnJlbnRUYWJsZU5h bWUgfHwgJyAoZjEgaW50ZWdlciwgZjIKaW50ZWdlciwgZjMgdmFyY2hhcigx MDApLCBmNCB2YXJjaGFyKDEwMCksIGY1IHZhcmNoYXIoMTAwKSwgZjYgdmFy Y2hhcigxMDApLApmNyBib29sZWFuLCBmOCBib29sZWFuLCBmOSBpbnRlZ2Vy LCBmMTAgaW50ZWdlciknOw0KICAgICAgICAgaWYgKGNyZWF0ZVZpZXdGb3JF YWNoVGFibGUgPSB0cnVlKSB0aGVuDQogICAgICAgICAgICBjdXJyZW50Vmll d05hbWUgOj0gY3VycmVudFNjaGVtYU5hbWUgfHwgJy4nIHx8ICd2aWV3JyB8 fApsdHJpbShjdXJyZW50VGFibGVJZDo6dmFyY2hhcigxMCkpOw0KICAgICAg ICAgICAgZXhlY3V0ZSAnY3JlYXRlIHZpZXcgJyB8fCBjdXJyZW50Vmlld05h bWUgfHwgJyBhcyAnIHx8DQogICAgICAgICAgICAgICAgICAgICAnc2VsZWN0 IHQxLiogZnJvbSAnIHx8IGN1cnJlbnRUYWJsZU5hbWUgfHwgJyB0MSAnIHx8 DQogICAgICAgICAgICAgJyBpbm5lciBqb2luICcgfHwgY3VycmVudFRhYmxl TmFtZSB8fCAnIHQyIG9uICh0MS5mMSA9IHQyLmYxKSAnCnx8DQogICAgICAg ICAgICAgJyBpbm5lciBqb2luICcgfHwgY3VycmVudFRhYmxlTmFtZSB8fCAn IHQzIG9uICh0Mi5mMiA9IHQzLmYyKSAnCnx8DQogICAgICAgICAgICAgJyBp bm5lciBqb2luICcgfHwgY3VycmVudFRhYmxlTmFtZSB8fCAnIHQ0IG9uICh0 My5mMyA9IHQ0LmYzKSAnCnx8DQogICAgICAgICAgICAgJyBpbm5lciBqb2lu ICcgfHwgY3VycmVudFRhYmxlTmFtZSB8fCAnIHQ1IG9uICh0NC5mNCA9IHQ1 LmY0KSAnCnx8DQogICAgICAgICAgICAgJyBpbm5lciBqb2luICcgfHwgY3Vy cmVudFRhYmxlTmFtZSB8fCAnIHQ2IG9uICh0NS5mNSA9IHQ2LmY1KSAnCnx8 DQogICAgICAgICAgICAgJyBpbm5lciBqb2luICcgfHwgY3VycmVudFRhYmxl TmFtZSB8fCAnIHQ3IG9uICh0Ni5mNiA9IHQ3LmY2KSAnCnx8DQogICAgICAg ICAgICAgJyBpbm5lciBqb2luICcgfHwgY3VycmVudFRhYmxlTmFtZSB8fCAn IHQ4IG9uICh0Ny5mNyA9IHQ4LmY3KSAnCnx8DQogICAgICAgICAgICAgJyBp bm5lciBqb2luICcgfHwgY3VycmVudFRhYmxlTmFtZSB8fCAnIHQ5IG9uICh0 OC5mOCA9IHQ5LmY4KSAnCnx8DQogICAgICAgICAgICAgJyBpbm5lciBqb2lu ICcgfHwgY3VycmVudFRhYmxlTmFtZSB8fCAnIHQxMCBvbiAodDkuZjkgPSB0 MTAuZjkpCic7ICAgICAgICAgICAgICAgICAgICANCiAgICAgICAgIGVuZCBp ZjsNCiAgICAgICAgIGN1cnJlbnRUYWJsZUlkIDo9IGN1cnJlbnRUYWJsZUlk ICsgMTsNCiAgICAgICAgIGNvdW50IDo9IGNvdW50ICsgMTsNCiAgICAgICAg IGlmIChjdXJyZW50VGFibGVJZCA+IG51bWJlck9mVGFibGVzUGVyU2NoZW1h KSB0aGVuIGV4aXQ7IGVuZCBpZjsNCiAgICAgIGVuZCBsb29wOyAgIA0KDQog ICAgICBjdXJyZW50U2NoZW1hSWQgOj0gY3VycmVudFNjaGVtYUlkICsgMTsN CiAgICAgIGlmIChjdXJyZW50U2NoZW1hSWQgPiBudW1iZXJPZlNjaGVtYXMp IHRoZW4gZXhpdDsgZW5kIGlmOyAgICAgDQogICBlbmQgbG9vcDsNCiAgIHJl dHVybiBjb3VudDsNCkVORCAkJCBsYW5ndWFnZSBwbHBnc3FsOw0KDQotLSBN VERCX1J1blRlc3RzDQpjcmVhdGUgb3IgcmVwbGFjZSBmdW5jdGlvbiBNVERC X1J1blRlc3RzKHNjaGVtYU5hbWVQcmVmaXggdmFyY2hhcigxMDApLApyb3Vu ZHMgaW50ZWdlcikNCnJldHVybnMgaW50ZWdlciBhcyAkJA0KZGVjbGFyZQ0K ICAgY3VyczEgY3Vyc29yKHByZWZpeCB2YXJjaGFyKSBpcyBzZWxlY3QgdGFi bGVfc2NoZW1hIHx8ICcuJyB8fCB0YWJsZV9uYW1lCmZyb20gaW5mb3JtYXRp b25fc2NoZW1hLnRhYmxlcyB3aGVyZSB0YWJsZV9zY2hlbWEgbGlrZSBwcmVm aXggfHwgJyUnIGFuZAp0YWJsZV90eXBlID0gJ1ZJRVcnOw0KICAgY3VycmVu dFZpZXdOYW1lIHZhcmNoYXIoMTAwKTsNCiAgIGNvdW50IGludGVnZXI7DQpi ZWdpbg0KICAgY291bnQgOj0gMDsNCiAgIGxvb3ANCiAgICAgIHJvdW5kcyA6 PSByb3VuZHMgLSAxOw0KICAgICAgaWYgKHJvdW5kcyA8IDApIHRoZW4gZXhp dDsgZW5kIGlmOw0KDQogICAgICBvcGVuIGN1cnMxKHNjaGVtYU5hbWVQcmVm aXgpOw0KICAgICAgbG9vcA0KICAgICAgICAgZmV0Y2ggY3VyczEgaW50byBj dXJyZW50Vmlld05hbWU7DQogICAgICAgICBpZiBub3QgZm91bmQgdGhlbiBl eGl0OyBlbmQgaWY7DQogICAgICAgICBleGVjdXRlICdzZWxlY3QgKiBmcm9t ICcgfHwgY3VycmVudFZpZXdOYW1lOw0KICAgICAgICAgY291bnQgOj0gY291 bnQgKyAxOw0KICAgICAgZW5kIGxvb3A7DQogICAgICBjbG9zZSBjdXJzMTsN CiAgIGVuZCBsb29wOw0KICAgcmV0dXJuIGNvdW50OyAgDQplbmQgJCQgbGFu Z3VhZ2UgcGxwZ3NxbDsNCg0KdGVzdCBTUUw6DQpwcmVwYXJlIDogDQpwb3N0 Z3Jlcz0jIHNlbGVjdCBNVERCX0luaXRpYWxpemUoJ3RlbmFudCcsIDEwMCwg MTAwMCwgdHJ1ZSk7DQoNCnNlc3Npb24gMSA6IA0KcG9zdGdyZXM9IyBzZWxl Y3QgTVREQl9SdW5UZXN0cygndGVuYW50JywgMSk7DQogbXRkYl9ydW50ZXN0 cyANCi0tLS0tLS0tLS0tLS0tLQ0KICAgICAgICAxMDAwMDANCigxIHJvdykN Cg0Kc2Vzc2lvbiAyIDogDQpwb3N0Z3Jlcz0jIHNlbGVjdCBNVERCX1J1blRl c3RzKCd0ZW5hbnQnLCAxKTsNCiBtdGRiX3J1bnRlc3RzIA0KLS0tLS0tLS0t LS0tLS0tDQogICAgICAgIDEwMDAwMA0KKDEgcm93KQ0KDQptZW1vcnkgdmll dyA6IA0KICBQSUQgVVNFUiAgICAgIFBSICBOSSAgICBWSVJUICAgIFJFUyAg ICBTSFIgUyAgJUNQVSAlTUVNICAgICBUSU1FKwpDT01NQU5EDQogMjUzNiBk aWdvYWwgICAgMjAgICAwIDIwLjgyOWcgMC4wMTZ0IDEuNzg2ZyBTICAgMC4w IDI1LjcgICAzOjA4LjIwCnBvc3RncmVzOiBwb3N0Z3JlcyBwb3N0Z3JlcyBb bG9jYWxdIGlkbGUNCiAyNDUzIGRpZ29hbCAgICAyMCAgIDAgNjg1NDg5NiAx ODcxMjQgMTQyNzgwIFMgICAwLjAgIDAuMyAgIDA6MDAuNjgKcG9zdGdyZXM6 IHBvc3RncmVzIHBvc3RncmVzIFtsb2NhbF0gaWRsZQ0KDQpzbWVtDQogIFBJ RCBVc2VyICAgICBDb21tYW5kICAgICAgICAgICAgICAgICAgICAgICAgIFN3 YXAgICAgICBVU1MgICAgICBQU1MgICAgIApSU1MgDQogMjUzNiBkaWdvYWwg ICBwb3N0Z3JlczogcG9zdGdyZXMgcG9zdGdyZXMgICAgICAgIDAgMTUwMjIx MzIgMTU1MzUyMDMKMTY4OTQ5MDAgDQogMjQ1MyBkaWdvYWwgICBwb3N0Z3Jl czogcG9zdGdyZXMgcG9zdGdyZXMgICAgICAgIDAgMTUwMjIyNTYgMTU1MzU0 MDUKMTY4OTUxMDAgDQoNCndoeSBQb3N0Z3JlU1FMIHNlc3Npb24gZG8gbm90 IHJlbGVhc2UgdGhlc2UgbWVtb3J5Pw0KaXQgd2lsbCBjb21zdW1lIHRoZXNl IG1lbW9yeSB1bnRpbCBkaXNjb25uZWN0LiAgDQoNCkkgdXNlIGRpc2NhcmQg YWxsIGNhbm4ndCByZWxlYXNlIHRoZSBzZXNzaW9uJ3MgbWVtb3J5LiAgCgo=
В списке pgsql-bugs по дате отправления:
Следующее
От: Peter EisentrautДата:
Сообщение: Re: BUG #14217: Respect $CFLAGS from /usr/local/etc/config.site