Thread: BUG #14234: PostgreSQL consuming large amount of memory for persistent connection

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=

digoal@126.com writes:
> why PostgreSQL session do not release these memory?
> it will comsume these memory until disconnect.

Your session has created and accessed 100000 tables plus 100000 views.
I do not think you should complain if that takes a great deal of memory.
Either rethink why you need so many tables, or buy hardware commensurate
with the size of your problem.

            regards, tom lane

Hi

2016-07-08 7:11 GMT+02:00 =E5=BE=B7=E5=93=A5 <digoal@126.com>:

>
> HI,
>    This is a reproduce method for why PostgreSQL session cann't release
> memory.
>    I have another case, has the same problem.
>    so i don't known why postgres cann't release memory? or can you explai=
n
> these memory contain which objects? why use this design?
> best regards,
> digoal
>

Every PostgreSQL session holds system data in own cache. Usually this cache
is pretty small (for significant numbers of users). But can be pretty big
if your catalog is untypically big and you touch almost all objects from
catalog in session. A implementation of this cache is simple - there is not
delete or limits. There is not garabage collector (and issue related to
GC), what is great, but the long sessions on big catalog can be problem.
The solution is simple - close session over some time or over some number
of operations. Then all memory in caches will be released.

Regards

Pavel



>
>
>
> --
> =E5=85=AC=E7=9B=8A=E6=98=AF=E4=B8=80=E8=BE=88=E5=AD=90=E7=9A=84=E4=BA=8B,=
I'm Digoal,Just Do It.
>
>
> At 2016-07-08 10:01:18, "Tom Lane" <tgl@sss.pgh.pa.us> wrote:
> >digoal@126.com writes:
> >> why PostgreSQL session do not release these memory?
> >> it will comsume these memory until disconnect.
> >
> >Your session has created and accessed 100000 tables plus 100000 views.
> >I do not think you should complain if that takes a great deal of memory.
> >Either rethink why you need so many tables, or buy hardware commensurate
> >with the size of your problem.
> >
> >            regards, tom lane
>
>