Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hazvN-0002OV-Et for pgsql-bugs@arkaria.postgresql.org; Wed, 12 Jun 2019 09:52:09 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hazvM-0006p9-8q for pgsql-bugs@arkaria.postgresql.org; Wed, 12 Jun 2019 09:52:08 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hazvL-0006nS-W3 for pgsql-bugs@lists.postgresql.org; Wed, 12 Jun 2019 09:52:08 +0000 Received: from wrigleys.postgresql.org ([2620:122:b000:7::246]) by magus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hazvJ-0002Oc-8o for pgsql-bugs@lists.postgresql.org; Wed, 12 Jun 2019 09:52:07 +0000 Content-Type: multipart/mixed; boundary="===============1709812686905850611==" MIME-Version: 1.0 Subject: BUG #15847: Running out of memory when planning full outer joins involving many partitions To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: feikesteenbergen@gmail.com Reply-To: feikesteenbergen@gmail.com, pgsql-bugs@lists.postgresql.org Date: Wed, 12 Jun 2019 09:51:07 +0000 Message-ID: <15847-ea3734094bf8ae61@postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============1709812686905850611== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNTg0NwpMb2dnZWQgYnk6ICAgICAgICAgIEZlaWtlIFN0ZWVuYmVyZ2Vu CkVtYWlsIGFkZHJlc3M6ICAgICAgZmVpa2VzdGVlbmJlcmdlbkBnbWFpbC5jb20KUG9zdGdyZVNR TCB2ZXJzaW9uOiAxMS4zCk9wZXJhdGluZyBzeXN0ZW06ICAgVWJ1bnR1IDE4LjA0LjIgTFRTCkRl c2NyaXB0aW9uOiAgICAgICAgCgpIaSBhbGwsDQoNCldlJ3ZlIGhhZCBhIGZldyByZXBvcnRzIHJl Y2VudGx5IHRoYXQgaGFkIGEgYmFja2VuZCBjb25zdW1lIGEgbG90IG9mCm1lbW9yeQ0KY2F1c2lu ZyBlaXRoZXIgYW4gT09NLWtpbGwgb3Iga3ViZXJuZXRlcyByZXNjaGVkdWxpbmcgdGhlaXIgUG9z dGdyZVNRTApwb2QuDQoNClRoZSBhY3R1YWwgcmVwb3J0IGFuZCBzb21lIGdyYXBocyBhbmQgZGV0 YWlscyBjYW4gYmUgZm91bmQgaGVyZToNCmh0dHBzOi8vZ2l0aHViLmNvbS90aW1lc2NhbGUvdGlt ZXNjYWxlZGIvaXNzdWVzLzEyNzQNCg0KTm90ZTogVGhlIGJlaGF2aW9yIGlzIG5vdCBUaW1lc2Nh bGVEQiBzcGVjaWZpYywgaXQgYWxzbyBoYXBwZW5zIG9uIGEKdmFuaWxsYQ0KUG9zdGdyZVNRTCBp bnN0YWxsYXRpb24gd2l0aG91dCBUaW1lc2NhbGUgaW5zdGFsbGVkLg0KDQpGb3IgdGhpcyBzcGVj aWZpYyBidWcgcmVwb3J0IHRoZXJlIHdlcmUgdHdvIHRoaW5ncyB0aGF0IGNsZWFybHkgc3Rvb2Qg b3V0Og0KDQotIGEgRlVMTCBPVVRFUiBKT0lOIGlzIGRvbmUNCi0gbWFueSBwYXJ0aXRpb25zICh0 aG91c2FuZHMpIGFyZSBpbnZvbHZlZA0KDQpUaGUgcHJvYmxlbWF0aWMgYmVoYXZpb3IgaXMgYXMg Zm9sbG93czoNCg0KV2hpbGUgcGxhbm5pbmcgYSBxdWVyeSwgdGhlIGJhY2tlbmQgdXNlcyBhIGZ1 bGwgQ1BVIGFuZCBpdCdzIG1lbW9yeSBrZWVwcw0KaW5jcmVhc2luZyB1bnRpbCBlaXRoZXI6DQoN Ci0gRVJST1I6IDUzMjAwOiBvdXQgb2YgbWVtb3J5IGZvciBzeXN0ZW1zIHdpdGggb3ZlcmNvbW1p dCBkaXNhYmxlZA0KLSBvciBraWxsZWQgYnkgT09NDQotIG9yIHJlc2NoZWR1bGVkIChrdWJlcm5l dGVzKQ0KDQpUaGUgYmFja2VuZCBzZWVtcyB0byBiZSBpbiBhZGRfY2hpbGRfcmVsX2VxdWl2YWxl bmNlcyBkdXJpbmcgdGhpcyB0aW1lIGFuZApkb2VzDQpub3QgcmVzcG9uZCB0byBTSUdJTlQgd2hp bGUgaXQgaXMgaW4gdGhlcmUuDQoNCkkndmUgZW5jb3VudGVyZWQgdGhpcyBwcm9ibGVtIG9uIDEx LjMsIDEwLjggYW5kIDkuNi4xMyAod2l0aCB0YWJsZQppbmhlcml0YW5jZQ0KaW5zdGVhZCBvZiBk ZWNsYXJhdGl2ZSBwYXJ0aXRpb25pbmcpLg0KDQpyZWdhcmRzLA0KDQpGZWlrZSBTdGVlbmJlcmdl bg0KDQoNCg0KLyoNClRoZSBiZWxvdyBTUUwgc2hvdWxkIHJlcHJvZHVjZSB0aGUgaXNzdWUgb24g YSBtYWNoaW5lIHdpdGggPD0gMTZHQiBtZW1vcnk6DQoNClRoaXMgaXMgYSBzdXJyb2dhdGUgdGVz dCBjYXNlIHRvIHRyaWdnZXIgdGhlIHByb2JsZW1hdGljIGJlaGF2aW9yLg0KDQpUaGUgYWN0dWFs IHJlcG9ydCBvZiB0aGUgdXNlciBpbnZvbHZlZCBtdWx0aXBsZSB0YWJsZXMsIGJ1dCB0byBzaW1w bGlmeQ0KdGhpbmdzIGhlcmUgSSdtIGp1c3QgcmV1c2luZyB0aGUgc2FtZSBwYXJ0aXRpb25lZCB0 YWJsZSB3aXRoIGEgbG90IG9mCnBhcnRpdGlvbnMNCiovDQoNCkNSRUFURSBUQUJMRSBidWdneSgN CiAgICBpbnNlcnRlZCB0aW1lc3RhbXB0eiBub3QgbnVsbA0KKQ0KUEFSVElUSU9OIEJZIFJBTkdF IChpbnNlcnRlZCk7DQoNCi0tIENyZWF0ZSBzb21lIHBhcnRpdGlvbnMNCkRPICRCT0RZJA0KREVD TEFSRQ0KICAgIHBhcnRuYW1lIHRleHQ7DQogICAgc3RhcnQgZGF0ZSA6PSBkYXRlX3RydW5jKCd3 ZWVrJywgJzE5OTktMTItMzEnOjpkYXRlKTsNCkJFR0lODQogICAgRk9SIGkgSU4gMC4uMTAwMCBM T09QDQogICAgICAgIHBhcnRuYW1lIDo9IGZvcm1hdCgnYnVnZ3lfJXMnLCB0b19jaGFyKHN0YXJ0 LCAnSVlZWUlXJykpOw0KICAgICAgICBFWEVDVVRFIGZvcm1hdCggJCRDUkVBVEUgVEFCTEUgJUkg UEFSVElUSU9OIE9GICVJDQogICAgICAgICAgICAgICAgICAgICAgICAgIEZPUiBWQUxVRVMgRlJP TSAoJUwpIFRPICglTCkkJCwNCiAgICAgICAgICAgICAgICAgICAgICAgIHBhcnRuYW1lLA0KICAg ICAgICAgICAgICAgICAgICAgICAgJ2J1Z2d5JywNCiAgICAgICAgICAgICAgICAgICAgICAgIHN0 YXJ0LA0KICAgICAgICAgICAgICAgICAgICAgICAgc3RhcnQgKyA3DQogICAgICAgICAgICAgICAg KTsNCiAgICAgICAgc3RhcnQgOj0gc3RhcnQgKyA3Ow0KICAgIEVORCBMT09QOw0KRU5EOw0KJEJP RFkkOw0KDQoNCi0tIFRoaXMgd29ya3MgZmluZQ0KRVhQTEFJTg0KU0VMRUNUDQogICAgaW5zZXJ0 ZWQNCkZST00NCiAgICBidWdneSBiMQ0KTEVGVCBKT0lODQogICAgYnVnZ3kgYjIgVVNJTkcgKGlu c2VydGVkKQ0KTEVGVCBKT0lODQogICAgYnVnZ3kgYjMgVVNJTkcgKGluc2VydGVkKQ0KTEVGVCBK T0lODQogICAgYnVnZ3kgYjQgVVNJTkcgKGluc2VydGVkDQopOw0KDQovKg0KVGhpcyB3aWxsIGVp dGhlciBkbyB0aGUgZm9sbG93aW5nOg0KLSBgRVJST1I6ICA1MzIwMDogb3V0IG9mIG1lbW9yeWAg Zm9yIHN5c3RlbXMgd2l0aCBvdmVyY29tbWl0IGRpc2FibGVkLCBvcg0KLSBhbiBvdXQtb2YtbWVt b3J5IGtpbGwgKGtlcm5lbCkNCi0gcmVzY2hlZHVsaW5nIG9mIHRoZSBwb2QgKGs4cykNCiovDQpF WFBMQUlODQpTRUxFQ1QNCiAgICBpbnNlcnRlZA0KRlJPTQ0KICAgIGJ1Z2d5IGIxDQpGVUxMIE9V VEVSIEpPSU4NCiAgICBidWdneSBiMiBVU0lORyAoaW5zZXJ0ZWQpDQpGVUxMIE9VVEVSIEpPSU4N CiAgICBidWdneSBiMyBVU0lORyAoaW5zZXJ0ZWQpDQpGVUxMIE9VVEVSIEpPSU4NCiAgICBidWdn eSBiNCBVU0lORyAoaW5zZXJ0ZWQpDQo7Cgo= --===============1709812686905850611==--