BUG #14403: Large numbers of CREATE OR UPDATE function causes memory exhaustion

Поиск
Список
Период
Сортировка
От will.pearson@digital.cabinet-office.gov.uk
Тема BUG #14403: Large numbers of CREATE OR UPDATE function causes memory exhaustion
Дата
Msg-id 20161028162317.15991.74004@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #14403: Large numbers of CREATE OR UPDATE function causes memory exhaustion  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
Дерево обсуждения 
VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJz
aXRlOgoKQnVnIHJlZmVyZW5jZTogICAgICAxNDQwMwpMb2dnZWQgYnk6ICAg
ICAgICAgIFdpbGwgUGVhcnNvbgpFbWFpbCBhZGRyZXNzOiAgICAgIHdpbGwu
cGVhcnNvbkBkaWdpdGFsLmNhYmluZXQtb2ZmaWNlLmdvdi51awpQb3N0Z3Jl
U1FMIHZlcnNpb246IDkuNi4xCk9wZXJhdGluZyBzeXN0ZW06ICAgT1NYIEVs
IENhcGl0YW4gKGFsc28gaW4gTGludXggQ29udGFpbmVycy9SRFMpCkRlc2Ny
aXB0aW9uOiAgICAgICAgCgpTdW1tYXJ5Og0KDQpXZSBoYWQgYSBwcm9ibGVt
IGluIHByb2R1Y3Rpb24gd2hlcmUgUkRTIGZhaWxlZCBvdmVyIGF2YWlsYWJp
bGl0eSB6b25lcy4gV2UKbGF0ZXIgZm91bmQgdGhpcyB3YXMgZHVlIHRvIGEg
bWVtb3J5IG92ZXJmbG93LiBEb2luZyBtb3JlIGRpZ2dpbmcgaXQgc2VlbXMK
dG8gZHVlIHRvIGxhcmdlIG51bWJlcnMgb2YgQ1JFQVRFIE9SIFVQREFURSBm
dW5jdGlvbnMgZG9uZSBieSBzZXF1ZWxpemUgKGEKbm9kZSBPUk0pIGR1cmlu
ZyBzZXNzaW9uIGNyZWF0aW9uLiBXZSd2ZSBtaXRpZ2F0ZWQgdGhlIHByb2Js
ZW0uDQoNCldlJ3ZlIG5vdyBpc29sYXRlZCB0aGUgcHJvYmxlbSBmcm9tIG91
ciBjb2RlIGFuZCBoYXZlIGNyZWF0ZWQgdGhlIGZvbGxvd2luZwpweXRob24g
c2NyaXB0IGRvaW5nIHN0YW5kYXJkIHNxbC4gICBCdXQgd2UgY291bGQgZG8g
d2l0aCBtb3JlIHVuZGVyc3RhbmRpbmcKb2YgcG9zdGdyZXNxbCBpbnRlcm5h
bHMgaG93IHRvIGRpZyBmdXJ0aGVyIChhbmQgYW55IHR1bmluZyBwb3NzaWJp
bGl0aWVzKS4KDQoNCi0tLS0NClB5dGhvbiBzY3JpcHQgdG8gcmVwbGljYXRl
IHRoZSBwcm9ibGVtcw0KDQppbXBvcnQgcHN5Y29wZzINCmltcG9ydCBzeXMN
Cg0KZGVmIGNyZWF0ZV9vcl9yZXBsYWNlIChuLCBjdXIsIGNvbm4pOg0KICBw
cmludCAoIkRvaW5nIGFjdGlvbiAiICsgc3RyKG4pKSANCiAgY3VyLmV4ZWN1
dGUoIkNSRUFURSBPUiBSRVBMQUNFIEZVTkNUSU9OIHBnX3RlbXAudGVzdGZ1
bmMoT1VUIHJlc3BvbnNlCnRlc3QsIE9VVCBzZXF1ZWxpemVfY2F1Z2h0X2V4
Y2VwdGlvbiB0ZXh0KSBSRVRVUk5TIFJFQ09SRCBBUyAkZnVuY19hNyIgKwpz
dHIobikgKyAiJCBCRUdJTiBJTlNFUlQgSU5UTyB0ZXN0IChcImlkXCIpIFZB
TFVFUyAoIiArIHN0cihuKSArICIpClJFVFVSTklORyAqIElOVE8gcmVzcG9u
c2U7IEVYQ0VQVElPTiBXSEVOIHVuaXF1ZV92aW9sYXRpb24gVEhFTiBHRVQg
U1RBQ0tFRApESUFHTk9TVElDUyBzZXF1ZWxpemVfY2F1Z2h0X2V4Y2VwdGlv
biA9IFBHX0VYQ0VQVElPTl9ERVRBSUw7IEVORCAkZnVuY19hNyIKKyBzdHIo
bikgKyAiJCBMQU5HVUFHRSBwbHBnc3FsOyIpDQogIGN1ci5leGVjdXRlKCJT
RUxFQ1QgKHRlc3RmdW5jLnJlc3BvbnNlKS4qLAp0ZXN0ZnVuYy5zZXF1ZWxp
emVfY2F1Z2h0X2V4Y2VwdGlvbiBGUk9NIHBnX3RlbXAudGVzdGZ1bmMoKTsi
KQ0KICBjdXIuZXhlY3V0ZSgiRFJPUCBGVU5DVElPTiBJRiBFWElTVFMgcGdf
dGVtcC50ZXN0ZnVuYygpOyIpDQogIGNvbm4uY29tbWl0KCkNCg0KZGVmIGxv
dHNfb2ZfY3JlYXRlX29yX3JlcGxhY2UodCwgY3VyLCBjb25uKSA6DQogIHBy
aW50ICgiRG9pbmcgbG90cyBvZiBhY3Rpb25zIGZvciB0IiArIHN0cih0KSkg
DQogIGZvciBuIGluIHJhbmdlKDEsIDEwMDAwMDAwMCk6DQogICAgIGNyZWF0
ZV9vcl9yZXBsYWNlKG4rdCwgY3VyLCBjb25uKQ0KICBwcmludCAiRmluaXNo
ZWQiDQoNCmNvbm4gPSBwc3ljb3BnMi5jb25uZWN0KCJkYm5hbWUgPXRlc3Rk
YiIpDQoNCmN1ciA9IGNvbm4uY3Vyc29yKCkNCmN1ci5leGVjdXRlKCJERUxF
VEUgRlJPTSB0ZXN0OyIpDQpsb3RzX29mX2NyZWF0ZV9vcl9yZXBsYWNlKGlu
dChzeXMuYXJndlsxXSksIGN1cixjb25uKQ0KDQojVXNhZ2UjDQpDcmVhdGUg
dGhlIHJlcXVpcmVkIHRhYmxlcyBhbmQgZGF0YWJhc2UgdGhlbiBydW4gaXQg
d2l0aCBhIHN0YXJ0aW5nIHBvaW50LgpUaGUgY29kZSBpcyBkZXNpZ25lZCBz
byB0aGF0IHlvdSBjYW4gcnVuIG11bHRpcGxlIGNvcGllcyBhdCBkaWZmZXJl
bnQKcG9pbnRzLg0KDQpMb29rIGF0IHRoZSBtZW1vcnkgdXNhZ2UgZ28gdXAg
b24gdGhlIHB5dGhvbiBwcm9jZXNzZXMuDQoNCktpbGxpbmcgdGhlIHB5dGhv
biBwcm9jZXNzIGRvaW5nIHRoZSB1cGRhdGVzIG1lYW5zIHRoZSBtZW1vcnkg
aXMgZnJlZWQuIE9uCnNvbWUgdGVzdHMgYWdhaW5zdCBvdXIgZGV2IGVudmly
b25tZW50cyBpdCBhcHBlYXJlZCB0aGF0IHNpbXBseSBzdG9wcGluZwpkb2lu
ZyB0aGUgcmVxdWVzdHMgdG8gY3JlYXRlIHNlc3Npb25zIGFsbG93ZWQgdGhl
IHN5c3RlbSB0byByZWNvdmVyIHRoZQptZW1vcnkuDQoNCi0tLS0NCk1vcmUg
ZGV0YWlsczoNCg0KU2VlbiBpbiBSRFMgKDkuNC40KQ0KbG9jYWxseSBpbiBN
YWMgOS41LjQNCk9uIExpbnV4IGluIGEgY29udGFpbmVyIDkuNC40DQoNClNl
cXVlbGl6ZSBjb2RlIHRoYXQgc2hvd3MgaXQgaW4gdGhlIHdpbGQ6DQoNCmh0
dHBzOi8vZ2l0aHViLmNvbS9zZXF1ZWxpemUvc2VxdWVsaXplL2Jsb2IvOTVk
M2E1NzEzNDk5YWI5MGIxOWQ3YTMxMmI4Y2I4NzhiMjZlYjFiNC9saWIvZGlh
bGVjdHMvYWJzdHJhY3QvcXVlcnktZ2VuZXJhdG9yLmpzI0wxNTQNCg0KLS0t
LQ0KDQpIeXBvdGhlc2VzIEkndmUgbG9va2VkIGF0IC0gUmVhc29uIEkgZG9u
J3QgdGhpbmsgdGhhdCBpcyB0aGUgcHJvYmxlbToNCg0KRnVuY3Rpb25zIGFy
ZW4ndCBiZWluZyBjbGVhbmVkIHVwIHByb3Blcmx5IC0gXGRmIGRvZXNuJ3Qg
c2hvdyBtb3JlIGZ1bmN0aW9ucwpkdXJpbmcgdGhlIHJ1bi4gQWx0aG91Z2gg
YSBjb2xsZWFndWUgcG9pbnRzIG91dCB0aGF0IHRoZXNlIHRlbXAgZnVuY3Rp
b25zCmFyZSBwZXIgY29ubmVjdGlvbiwgc28gd291bGRuJ3Qgc2hvdyB1cC4g
V2UncmUgbm90IHN1cmUgaG93IHRvIHNlZSB0aGVtLg0KTm8gdmFjdXVtcyBo
YXBwZW5pbmcgLSBUaGVyZSBhcmUgdmFjdXVtcyBoYXBwZW5pbmcgZHVyaW5n
IG1lbW9yeSB1c2FnZQppbmNyZWFzZS4NCg0KQ3VycmVudCBoeXBvdGhlc2lz
Og0KDQpUaGUgcHJvY2VzcyB0aGF0IGZyZWVzIHVwIG1lbW9yeSBmb3IgdGVt
cG9yYXJ5IGZ1bmN0aW9ucyBkb2Vzbid0IGhhdmUgYQpjaGFuY2UgdG8gYWN0
IGJlY2F1c2Ugb2YgdGhlIGNvbnNpc3RlbnQgbnVtYmVyIG9mIGluc2VydHMg
YW5kIGRlbGV0aW9ucwpwcmUtZW1wdGluZyBpdC4gSXQgaXMgbm90IGEgbm9y
bWFsIHZhY3V1bSB0byBkZWFsIHdpdGggaXQuIA0KDQpUaGFua3MgZm9yIGFu
eSBoZWxwLA0KDQogV2lsbCBQZWFyc29uDQogV2ViT3BzCgo=

В списке pgsql-bugs по дате отправления:

Предыдущее
От: francois.atilio@gmail.com
Дата:
Сообщение: BUG #14400: pgAdmin 4 error 'utf8' codec can't decode byte...
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #14403: Large numbers of CREATE OR UPDATE function causes memory exhaustion