Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jaKr7-0007Bf-10 for pgsql-bugs@arkaria.postgresql.org; Sun, 17 May 2020 15:05:33 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jaKr5-0005Fa-OF for pgsql-bugs@arkaria.postgresql.org; Sun, 17 May 2020 15:05:31 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jaKVS-00078T-GI for pgsql-bugs@lists.postgresql.org; Sun, 17 May 2020 14:43:10 +0000 Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by magus.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jaKVL-0006wN-AC for pgsql-bugs@lists.postgresql.org; Sun, 17 May 2020 14:43:10 +0000 Content-Type: multipart/mixed; boundary="===============5640482418803150222==" MIME-Version: 1.0 Subject: BUG #16443: Too much memory usage on insert query To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: kurt@roeckx.be Reply-To: kurt@roeckx.be, pgsql-bugs@lists.postgresql.org Date: Sun, 17 May 2020 14:42:09 +0000 Message-ID: <16443-030629aae2859708@postgresql.org> X-Auto-Response-Suppress: All List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============5640482418803150222== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjQ0MwpMb2dnZWQgYnk6ICAgICAgICAgIEt1cnQgUm9lY2t4CkVtYWls IGFkZHJlc3M6ICAgICAga3VydEByb2Vja3guYmUKUG9zdGdyZVNRTCB2ZXJzaW9uOiAxMi4zCk9w ZXJhdGluZyBzeXN0ZW06ICAgRGViaWFuCkRlc2NyaXB0aW9uOiAgICAgICAgCgpIaSwNCg0KSSBo YXZlIHRoaXMgaW4gbXkgY29uZmlnIGZpbGU6DQpzaGFyZWRfYnVmZmVycyA9IDIwNDhNQiAgICAg ICAgICAgICAgICAgIyBtaW4gMTI4a0INCndvcmtfbWVtID0gMTAyNE1CICAgICAgICAgICAgICAg ICAgICAgICAjIG1pbiA2NGtCDQoNCkkgd2FzIGV4ZWN1dGluZyB0aGlzIHF1ZXJ5Og0KaW5zZXJ0 IGludG8gY3RfZW50cnlfY2hhaW4gKGN0X2VudHJ5X2lkLCBjZXJ0aWZpY2F0ZV9pZCkgc2VsZWN0 IGlkLAp1bm5lc3QoY2VydGlmaWNhdGVfY2hhaW5faWQpIGZyb20gY3RfZW50cnk7DQoNClRoZSBw cm9jZXNzIHdhcyB1c2luZyBhdCBsZWFzdCAxNCBHQiwgb2YgdGhlIDggR0Igb2YgUkFNIHRoYXQn cyBhdmFpbGFibGUuClN3YXAgd2FzIGFsc28gdXNpbmcgYXJvdW5kIHRoZSA4R0IgbWF4aW11bSwg d2hpbGUgbm9ybWFsbHkgYXJvdW5kIDIwMCBNQiBpcwpzd2FwcGVkIG91dC4gSSBkaWRuJ3QgZXhw ZWN0IHRoaXMgcHJvY2VzcyB0byB1c2UgbW9yZSB0aGFuIGFyb3VuZCAzIEdCLg0KDQpUaGlzIGhh cyByZXN1bHRlZCBpbiBhbiBvdXQgb2YgbWVtb3J5IGNvbmRpdGlvbi4NCg0KSSB3YXMgY29udmVy dGluZyBteSBzY2hlbWEsIGN0X2VudHJ5X2NoYWluIGlzIGEgbmV3IHRhYmxlIHRoYXQgbG9va3Mg bGlrZToNCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgVGFibGUgInB1YmxpYy5jdF9l bnRyeV9jaGFpbiINCiAgICAgQ29sdW1uICAgICB8ICBUeXBlICB8IENvbGxhdGlvbiB8IE51bGxh YmxlIHwgICAgICAgICAgICAgICAgICBEZWZhdWx0DQotLS0tLS0tLS0tLS0tLS0tKy0tLS0tLS0t Ky0tLS0tLS0tLS0tKy0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0NCiBpZCAgICAgICAgICAgICB8IGJpZ2ludCB8ICAgICAgICAgICB8IG5vdCBu dWxsIHwKbmV4dHZhbCgnY3RfZW50cnlfY2hhaW5faWRfc2VxJzo6cmVnY2xhc3MpDQogY3RfZW50 cnlfaWQgICAgfCBiaWdpbnQgfCAgICAgICAgICAgfCBub3QgbnVsbCB8DQogY2VydGlmaWNhdGVf aWQgfCBiaWdpbnQgfCAgICAgICAgICAgfCBub3QgbnVsbCB8DQpJbmRleGVzOg0KICAgICJjdF9l bnRyeV9jaGFpbl9wa2V5IiBQUklNQVJZIEtFWSwgYnRyZWUgKGlkKQ0KICAgICJjdF9lbnRyeV9j aGFpbl9jdF9lbnRyeV9pZF9jZXJ0aWZpY2F0ZV9pZF9rZXkiIFVOSVFVRSBDT05TVFJBSU5ULCBi dHJlZQooY3RfZW50cnlfaWQsIGNlcnRpZmljYXRlX2lkKQ0KRm9yZWlnbi1rZXkgY29uc3RyYWlu dHM6DQogICAgImN0X2VudHJ5X2NoYWluX2NlcnRpZmljYXRlX2lkX2ZrZXkiIEZPUkVJR04gS0VZ IChjZXJ0aWZpY2F0ZV9pZCkKUkVGRVJFTkNFUyByYXdfY2VydGlmaWNhdGVzKGlkKQ0KICAgICJj dF9lbnRyeV9jaGFpbl9jdF9lbnRyeV9pZF9ma2V5IiBGT1JFSUdOIEtFWSAoY3RfZW50cnlfaWQp IFJFRkVSRU5DRVMKY3RfZW50cnkoaWQpDQoNCmN0X2VudHJ5IGl0c2VsZiBsb29rcyBsaWtlOg0K ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBUYWJsZSAicHVibGlj LmN0X2VudHJ5Ig0KICAgICAgICBDb2x1bW4gICAgICAgIHwgICAgICAgICAgIFR5cGUgICAgICAg ICAgIHwgQ29sbGF0aW9uIHwgTnVsbGFibGUgfCAgIAogICAgICAgICAgIERlZmF1bHQNCi0tLS0t LS0tLS0tLS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0r LS0tLS0tLS0tLSstLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0KIGlkICAg ICAgICAgICAgICAgICAgIHwgYmlnaW50ICAgICAgICAgICAgICAgICAgIHwgICAgICAgICAgIHwg bm90IG51bGwgfApuZXh0dmFsKCdjdF9lbnRyeV9pZF9zZXEnOjpyZWdjbGFzcykNCiBjdF9sb2df aWQgICAgICAgICAgICB8IGludGVnZXIgICAgICAgICAgICAgICAgICB8ICAgICAgICAgICB8IG5v dCBudWxsIHwNCiByYXdfY2VydGlmaWNhdGVfaWQgICB8IGJpZ2ludCAgICAgICAgICAgICAgICAg ICB8ICAgICAgICAgICB8IG5vdCBudWxsIHwNCiBsb2dfZW50cnkgICAgICAgICAgICB8IGJpZ2lu dCAgICAgICAgICAgICAgICAgICB8ICAgICAgICAgICB8IG5vdCBudWxsIHwNCiB0aW1lc3RhbXAg ICAgICAgICAgICB8IHRpbWVzdGFtcCB3aXRoIHRpbWUgem9uZSB8ICAgICAgICAgICB8IG5vdCBu dWxsIHwNCiB2ZXJzaW9uICAgICAgICAgICAgICB8IGludGVnZXIgICAgICAgICAgICAgICAgICB8 ICAgICAgICAgICB8IG5vdCBudWxsIHwNCiBlbnRyeV90eXBlICAgICAgICAgICB8IGludGVnZXIg ICAgICAgICAgICAgICAgICB8ICAgICAgICAgICB8IG5vdCBudWxsIHwNCiBsZWFmX3R5cGUgICAg ICAgICAgICB8IGludGVnZXIgICAgICAgICAgICAgICAgICB8ICAgICAgICAgICB8IG5vdCBudWxs IHwNCiBleHRlbnNpb25zICAgICAgICAgICB8IGJ5dGVhICAgICAgICAgICAgICAgICAgICB8ICAg ICAgICAgICB8ICAgICAgICAgIHwNCiBpc3N1ZXJfa2V5X2hhc2ggICAgICB8IGJ5dGVhICAgICAg ICAgICAgICAgICAgICB8ICAgICAgICAgICB8ICAgICAgICAgIHwNCiBwcmVfY2VydGlmaWNhdGVf aWQgICB8IGJpZ2ludCAgICAgICAgICAgICAgICAgICB8ICAgICAgICAgICB8ICAgICAgICAgIHwN CiBjZXJ0aWZpY2F0ZV9jaGFpbl9pZCB8IGJpZ2ludFtdICAgICAgICAgICAgICAgICB8ICAgICAg ICAgICB8ICAgICAgICAgIHwNCkluZGV4ZXM6DQogICAgImN0X2VudHJ5X3BrZXkiIFBSSU1BUlkg S0VZLCBidHJlZSAoaWQpDQogICAgImN0X2VudHJ5X3Jhd19jZXJ0aWZpY2F0ZV9pZF9pZHgiIGJ0 cmVlIChyYXdfY2VydGlmaWNhdGVfaWQpDQpGb3JlaWduLWtleSBjb25zdHJhaW50czoNCiAgICAi Y3RfZW50cnlfY3RfbG9nX2lkX2ZrZXkiIEZPUkVJR04gS0VZIChjdF9sb2dfaWQpIFJFRkVSRU5D RVMKY3RfbG9ncyhpZCkNCiAgICAiY3RfZW50cnlfcHJlX2NlcnRpZmljYXRlX2lkX2ZrZXkiIEZP UkVJR04gS0VZIChwcmVfY2VydGlmaWNhdGVfaWQpClJFRkVSRU5DRVMgcmF3X2NlcnRpZmljYXRl cyhpZCkNCiAgICAiY3RfZW50cnlfcmF3X2NlcnRpZmljYXRlX2lkX2ZrZXkiIEZPUkVJR04gS0VZ IChyYXdfY2VydGlmaWNhdGVfaWQpClJFRkVSRU5DRVMgcmF3X2NlcnRpZmljYXRlcyhpZCkNClJl ZmVyZW5jZWQgYnk6DQogICAgVEFCTEUgImN0X2VudHJ5X2NoYWluIiBDT05TVFJBSU5UICJjdF9l bnRyeV9jaGFpbl9jdF9lbnRyeV9pZF9ma2V5IgpGT1JFSUdOIEtFWSAoY3RfZW50cnlfaWQpIFJF RkVSRU5DRVMgY3RfZW50cnkoaWQpCgo= --===============5640482418803150222==--