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 1jSFvF-0007BO-Cu for pgsql-bugs@arkaria.postgresql.org; Sat, 25 Apr 2020 08:12:25 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jSFvC-0005iW-N4 for pgsql-bugs@arkaria.postgresql.org; Sat, 25 Apr 2020 08:12:22 +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 1jSEw1-0004jw-Oj for pgsql-bugs@lists.postgresql.org; Sat, 25 Apr 2020 07:09:09 +0000 Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by magus.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jSEvw-00028o-Ai for pgsql-bugs@lists.postgresql.org; Sat, 25 Apr 2020 07:09:06 +0000 Content-Type: multipart/mixed; boundary="===============7947202241934512991==" MIME-Version: 1.0 Subject: BUG #16389: OOM on CTE since version 12 To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: rikard@ngs.hr Reply-To: rikard@ngs.hr, pgsql-bugs@lists.postgresql.org Date: Sat, 25 Apr 2020 07:08:06 +0000 Message-ID: <16389-c27249bee0a7ae28@postgresql.org> X-Auto-Response-Suppress: All List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============7947202241934512991== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjM4OQpMb2dnZWQgYnk6ICAgICAgICAgIFJpa2FyZCBQYXZlbGljCkVt YWlsIGFkZHJlc3M6ICAgICAgcmlrYXJkQG5ncy5ocgpQb3N0Z3JlU1FMIHZlcnNpb246IDEyLjIK T3BlcmF0aW5nIHN5c3RlbTogICBDZW50b3MgNywgTGludXggMy4xMApEZXNjcmlwdGlvbjogICAg ICAgIAoKSGksIHdlIGFyZSB0ZXN0aW5nIHVwZ3JhZGUgZnJvbSAxMSB0byAxMiBhbmQgZW5jb3Vu dGVyZWQgc29tZSBzdHJhbmdlCk9PTXMuDQpUaGlzIG9uZSB3YXMgY29uc2lzdGVudGx5IGhhcHBl bmluZyBvbiBzZXZlcmFsIGluc3RhbmNlcywgd2hpbGUgaXQgcGFzc2VkCm5vcm1hbGx5IG9uIG1h bnkgb3RoZXIgb25lczoNCg0Kb3JnLnBvc3RncmVzcWwudXRpbC5QU1FMRXhjZXB0aW9uOkVSUk9S OiBvdXQgb2YgbWVtb3J5DQogIERldGFpbDogRmFpbGVkIG9uIHJlcXVlc3Qgb2Ygc2l6ZSA1MiBp biBtZW1vcnkgY29udGV4dCAiRXhlY3V0b3JTdGF0ZSIuDQpXaGVyZTogIldJVEggc291cmNlIEFT ICgNCglTRUxFQ1QgDQoJCWksDQoJCXJvd19udW1iZXIoKSBvdmVyICgpIGFzIG9yZCwNCgkJKHQu b2xkKS5hbW91bnRfYXJyYXkgQVMgb2xkLA0KCQkodC5uZXcpLmFtb3VudF9hcnJheSBBUyBuZXcs DQoJCWNvYWxlc2NlKGFycmF5X3VwcGVyKCh0Lm9sZCkuYW1vdW50X2FycmF5LCAxKSwgMCkgQVMg b2xkX2NvdW50LA0KCQljb2FsZXNjZShhcnJheV91cHBlcigodC5uZXcpLmFtb3VudF9hcnJheSwg MSksIDApIEFTIG5ld19jb3VudCwNCgkJKFNFTEVDVCBhcnJheV9hZ2cocm93KF9yLnBrMSwgX3Iu cGsyKSkgRlJPTSB1bm5lc3QoKHQub2xkKS5hbW91bnRfYXJyYXkpCl9yKSBhcyBvbGRfcGtzLA0K CQkoU0VMRUNUIGFycmF5X2FnZyhyb3coX3IucGsxLCBfci5wazIpKSBGUk9NIHVubmVzdCgodC5u ZXcpLmFtb3VudF9hcnJheSkKX3IpIGFzIG5ld19wa3MsDQoJCShTRUxFQ1QgYXJyYXlfYWdnKGkp IEZST00gZ2VuZXJhdGVfc2VyaWVzKDEsIENBU0UgV0hFTgpjb2FsZXNjZShhcnJheV91cHBlcigo dC5vbGQpLmFtb3VudF9hcnJheSwgMSksIDApID4KY29hbGVzY2UoYXJyYXlfdXBwZXIoKHQubmV3 KS5hbW91bnRfYXJyYXksIDEpLCAwKSBUSEVOCmFycmF5X3VwcGVyKCh0Lm9sZCkuYW1vdW50X2Fy cmF5LCAxKSBFTFNFIGFycmF5X3VwcGVyKCh0Lm5ldykuYW1vdW50X2FycmF5LAoxKSBFTkQpIGkp IGFzIGluZGV4ZXMNCglGUk9NIGdsb2JhbF90ZW1wX2lucHV0X3RhYmxlIHQNCglXSEVSRSANCgkJ Tk9UICh0Lm9sZCkuYW1vdW50X2FycmF5IElTIE5VTEwgQU5EICh0Lm5ldykuYW1vdW50X2FycmF5 IElTIE5VTEwNCgkJT1IgKHQub2xkKS5hbW91bnRfYXJyYXkgSVMgTlVMTCBBTkQgTk9UICh0Lm5l dykuYW1vdW50X2FycmF5IElTIE5VTEwNCgkJT1IgTk9UICh0Lm9sZCkuYW1vdW50X2FycmF5IElT IE5VTEwgQU5EIE5PVCAodC5uZXcpLmFtb3VudF9hcnJheSBJUyBOVUxMCkFORCAodC5vbGQpLmFt b3VudF9hcnJheSAhPSAodC5uZXcpLmFtb3VudF9hcnJheQ0KKQ0KSU5TRVJUIElOVE8gZ2xvYmFs X3RlbXBfdXBkYXRlDQpTRUxFQ1QgaSwgaW5kZXgsIG9sZFtpbmRleF0gQVMgb2xkLCANCglDQVNF IA0KCQlXSEVOIG9sZF9wa3NbaW5kZXhdID0gbmV3X3Brc1tpbmRleF0gVEhFTiBuZXdbaW5kZXhd IA0KCQlXSEVOIE5PVCBDT0FMRVNDRShvbGRfcGtzW2luZGV4XSA9IEFOWSAobmV3X3BrcyksIGZh bHNlKSBUSEVOIG51bGwNCgkJRUxTRSAoc2VsZWN0IG4gZnJvbSB1bm5lc3QobmV3KSBuIHdoZXJl IG4ucGsxID0gb2xkW2luZGV4XS5wazEgQU5EIG4ucGsyID0Kb2xkW2luZGV4XS5wazIpDQoJRU5E IEFTIGNoYW5nZWQsDQoJbmV3W2luZGV4XSBBUyBuZXcsDQoJQ0FTRSBXSEVOIG9sZF9wa3NbaW5k ZXhdID0gbmV3X3Brc1tpbmRleF0gVEhFTiBmYWxzZSBFTFNFIE5PVApuZXdfcGtzW2luZGV4XSBJ UyBOVUxMIEFORCBOT1QgQ09BTEVTQ0UobmV3X3Brc1tpbmRleF0gPSBBTlkgKG9sZF9wa3MpLApm YWxzZSkgRU5EIEFTIGlzX25ldw0KRlJPTQ0KKA0KCVNFTEVDVCBpIGFzIF9pLCBvcmQgYXMgX29y ZCwgdW5uZXN0KChTRUxFQ1QgYXJyYXlfYWdnKGkpIEZST00KZ2VuZXJhdGVfc2VyaWVzKDEsIENB U0UgV0hFTiBvbGRfY291bnQgPiBuZXdfY291bnQgVEhFTiBvbGRfY291bnQgRUxTRQpuZXdfY291 bnQgRU5EKSBpKSkgYXMgaW5kZXgNCglGUk9NIHNvdXJjZSBzDQopIGl4DQpJTk5FUiBKT0lOIHNv dXJjZSBzcSBPTiBpeC5faSA9IHNxLmkgQU5EIGl4Ll9vcmQgPSBzcS5vcmQiDQoNClRoZSBnbG9i YWwgaW5wdXQgdGVtcCB0YWJsZXMgbG9vayBsaWtlIHRoaXMNCg0KQ1JFQVRFIFVOTE9HR0VEIFRB QkxFIGdsb2JhbF90ZW1wX2lucHV0X3RhYmxlDQooDQogICAgaSBpbnRlZ2VyLA0KICAgIG9sZCBk YXRhX3NvdXJjZV92aWV3LA0KICAgIG5ldyBkYXRhX3NvdXJjZV92aWV3DQopOw0KDQp3aGVyZSBk YXRhX3NvdXJjZV92aWV3IGlzIGFuIHZpZXcgd2l0aCBhbiBhcnJheSBvZiBjb21wb3NpdGVzIChh bW91bnRfYXJyYXkpCndoaWNoIGdldHMgdW5uZXN0ZWQgYW5kIGNvbXBhcmVkIGhlcmUuDQoNCldo aWxlIHRoZSBxdWVyeSBpcyBub3Qgb3B0aW1hbCwgdGhlIE9PTXMgc3RvcHBlZCBhZnRlciB3ZSBw dXQgTUFURVJJQUxJWkVECm9uIHRvcCAod2hpY2ggZG9lcyBub3Qgc2VlbSBuZWNlc3NhcnkgYXMg aXQncyB1c2VkIHR3aWNlKS4NCkFueXdheSwgaXQncyBub3QgYW4gaW1tZWRpYXRlIHByb2JsZW0g Zm9yIHVzIGFueW1vcmUsIGFzIHdlJ3ZlIHJld3JpdHRlbiBpdAppbnRvIGEgc2FuZXIgZm9ybSwN CmJ1dCBpdCBoaW50cyBhdCBzb21lIHVuZGVybHlpbmcgaXNzdWUgd2l0aCByZWNlbnQgQ1RFIG9w dGltaXphdGlvbi4NCg0KUmVnYXJkcywNClJpa2FyZAoK --===============7947202241934512991==--