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 1pRsbm-000508-T0 for pgsql-bugs@arkaria.postgresql.org; Tue, 14 Feb 2023 10:32:23 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pRsbl-0002DT-7v for pgsql-bugs@arkaria.postgresql.org; Tue, 14 Feb 2023 10:32:21 +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 1pRrhR-0003KW-Oj for pgsql-bugs@lists.postgresql.org; Tue, 14 Feb 2023 09:34:09 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pRrhO-0005fX-Cy for pgsql-bugs@lists.postgresql.org; Tue, 14 Feb 2023 09:34:09 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:Cc:From:To:Subject: MIME-Version:Content-Type:Sender:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=n/kIY/h65uhdIaEAzQYuXnBoAGOl8yOmww3GQzvYMrY=; b=3Xzde+28bRJ7CfgueX6KXIyY0/ 1LQbwub1Fj9ClqZZ1lnk5Yj5MR8p2yvR5sERS5zFxUWERXMTCfzxO3Jb2+KEgOXFMA1ChiqdR5zRS 2FZTiqIiql9adj2pRRtCUGhBLP8QSo/zW8tR65D0Iv8eJ8DcZ0S0TmDVLMbryIHT+Py3UeNPJLCwQ CuRDaslmEL+H9fI2+wmWF2wj7P5QIzGxLNTEOJ10gfHoHIqz03Z5E24oBqHMZesOsMdb50N2YR6l8 9SWhltMDXSgcF5JCsBoIeLjWd9qFTRGGGHEE2+/PX3BOhzUugJWIhytkkPs3S+jx5xXuTHHmeHjZm g86jplsQ==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pRrhM-0001Ar-1Y for pgsql-bugs@lists.postgresql.org; Tue, 14 Feb 2023 09:34:04 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1pRrhK-003geQ-RV for pgsql-bugs@lists.postgresql.org; Tue, 14 Feb 2023 09:34:02 +0000 Content-Type: multipart/mixed; boundary="===============5622634889178154547==" MIME-Version: 1.0 Subject: BUG #17793: Query with large number of joins crashes PostgreSQL To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: tom@quist.de Reply-To: tom@quist.de, pgsql-bugs@lists.postgresql.org Date: Tue, 14 Feb 2023 09:33:23 +0000 Message-ID: <17793-21fa598adbc21118@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============5622634889178154547== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzc5MwpMb2dnZWQgYnk6ICAgICAgICAgIFRvbQpFbWFpbCBhZGRyZXNz OiAgICAgIHRvbUBxdWlzdC5kZQpQb3N0Z3JlU1FMIHZlcnNpb246IDEzLjEwCk9wZXJhdGluZyBz eXN0ZW06ICAgRGViaWFuIDEwLjIuMS02IChEb2NrZXIgaW1hZ2UgcG9zdGdyZXM6MTMuMTApCkRl c2NyaXB0aW9uOiAgICAgICAgCgpIZXksDQoNCndlIGhhZCBhIHVuaXQgdGVzdCB0aGF0IHByb2R1 Y2VkIGEgc2ltaWxhciBxdWVyeSB0byB0aGUgZm9sbG93aW5nIG9uZSBhbmQKY2F1c2VkIFBvc3Rn cmVzIHRvIGNyYXNoIGFuZCByZWluaXRpYWxpemUgd2l0aCBhdXRvbWF0aWMgcmVjb3Zlcnk6Cmh0 dHBzOi8vZ2lzdC5naXRodWIuY29tL3RvbXF1aXN0L2E1OGI2MmQxYTE1Y2U5OWE2NzY1N2VkNjM2 MTI5ZTliDQoNClRoZXNlIGFyZSB0aGUgY2xpZW50IGxvZ3M6DQpzZXJ2ZXIgY2xvc2VkIHRoZSBj b25uZWN0aW9uIHVuZXhwZWN0ZWRseQ0KCVRoaXMgcHJvYmFibHkgbWVhbnMgdGhlIHNlcnZlciB0 ZXJtaW5hdGVkIGFibm9ybWFsbHkNCgliZWZvcmUgb3Igd2hpbGUgcHJvY2Vzc2luZyB0aGUgcmVx dWVzdC4NClRoZSBjb25uZWN0aW9uIHRvIHRoZSBzZXJ2ZXIgd2FzIGxvc3QuIEF0dGVtcHRpbmcg cmVzZXQ6IEZhaWxlZC4NCg0KVGhlc2UgYXJlIHRoZSBzZXJ2ZXIgbG9ncyB3aGVuIHRoZSBjcmFz aCBoYXBwZW5zOg0KMjAyMy0wMi0xNCAwOToxNzozMS40NDAgVVRDIFsxXSBMT0c6ICBzZXJ2ZXIg cHJvY2VzcyAoUElEIDM1KSB3YXMgdGVybWluYXRlZApieSBzaWduYWwgOTogS2lsbGVkDQoyMDIz LTAyLTE0IDA5OjE3OjMxLjQ0MCBVVEMgWzFdIERFVEFJTDogIEZhaWxlZCBwcm9jZXNzIHdhcyBy dW5uaW5nOiB3aXRoCmFwcF91c2VyIGFzIChzZWxlY3QgJ2EnIGFzIGlkLCAnb3JnYW5pemF0aW9u SWQnIGFzIG9yZ2FuaXphdGlvbl9pZCwKJ0FmcmljYS9BYmlkamFuJyBhcyB0aW1lem9uZSksDQoJ ZW1wbG95ZWUgYXMgKHNlbGVjdCAnYScgYXMgaWQsICdvcmdhbml6YXRpb25JZCcgYXMgb3JnYW5p emF0aW9uX2lkLCAnYScgYXMKdXNlcl9pZCwgJ2EnIGFzIG1hbmFnZXJfaWQpDQoJU0VMRUNUIERJ U1RJTkNUIGFwcF91c2VyLmlkIEZST00gYXBwX3VzZXIgTEVGVCBPVVRFUiBKT0lOIGVtcGxveWVl IEFTCmVtcGxveWVlXzEgT04gDQoJZW1wbG95ZWVfMS51c2VyX2lkID0gYXBwX3VzZXIuaWQgTEVG VCBPVVRFUiBKT0lOIGVtcGxveWVlIEFTCm1hbmFnZXJfZW1wbG95ZWVfMSBPTiAoZW1wbG95ZWVf MS5tYW5hZ2VyX2lkID0gbWFuYWdlcl9lbXBsb3llZV8xLmlkIEFORAptYW5hZ2VyX2VtcGxveWVl XzEudXNlcl9pZCBJTiAoU0VMRUNUIGFwcF91c2VyLmlkIEZST00gYXBwX3VzZXIgV0hFUkUKKGFw cF91c2VyLnRpbWV6b25lID0gJ0FmcmljYS9BYmlkamFuJyBBTkQgYXBwX3VzZXIub3JnYW5pemF0 aW9uX2lkID0KJ29yZ2FuaXphdGlvbklkJykpKQ0KCSBMRUZUIE9VVEVSIEpPSU4gZW1wbG95ZWUg QVMgZW1wbG95ZWVfMiBPTiANCgllbXBsb3llZV8yLnVzZXJfaWQgPSBhcHBfdXNlci5pZCBMRUZU IE9VVEVSIEpPSU4gZW1wbG95ZWUgQVMKbWFuYWdlcl9lbXBsb3llZV8yIE9OIChlbXBsb3llZV8y Lm1hbmFnZXJfaWQgPSBtYW5hZ2VyX2VtcGxveWVlXzIuaWQgQU5ECm1hbmFnZXJfZW1wbG95ZWVf Mi51c2VyX2lkIElOIChTRUxFQ1QgYXBwX3VzZXIuaWQgRlJPTSBhcHBfdXNlciBXSEVSRQooYXBw X3VzZXIudGltZXpvbmUgPSAnQWZyaWNhL0FsZ2llcnMnIEFORCBhcHBfdXNlci5vcmdhbml6YXRp b25faWQgPQonb3JnYW5pemF0aW9uSWQnKSkpDQoJIExFRlQgT1VURVIgSk9JTiBlbXBsb3llZSBB UyBlbXBsb3llZV8zIE9OIA0KCWVtcGxveWVlXzMudXNlcl9pZCA9IGFwcF91c2VyLmlkIExFRlQg T1VURVIgSk9JTiBlbXBsb3llZQ0KMjAyMy0wMi0xNCAwOToxNzozMS40NDIgVVRDIFsxXSBMT0c6 ICB0ZXJtaW5hdGluZyBhbnkgb3RoZXIgYWN0aXZlIHNlcnZlcgpwcm9jZXNzZXMNCjIwMjMtMDIt MTQgMDk6MTc6MzEuNDQ2IFVUQyBbMzJdIFdBUk5JTkc6ICB0ZXJtaW5hdGluZyBjb25uZWN0aW9u IGJlY2F1c2Ugb2YKY3Jhc2ggb2YgYW5vdGhlciBzZXJ2ZXIgcHJvY2Vzcw0KMjAyMy0wMi0xNCAw OToxNzozMS40NDYgVVRDIFszMl0gREVUQUlMOiAgVGhlIHBvc3RtYXN0ZXIgaGFzIGNvbW1hbmRl ZCB0aGlzCnNlcnZlciBwcm9jZXNzIHRvIHJvbGwgYmFjayB0aGUgY3VycmVudCB0cmFuc2FjdGlv biBhbmQgZXhpdCwgYmVjYXVzZQphbm90aGVyIHNlcnZlciBwcm9jZXNzIGV4aXRlZCBhYm5vcm1h bGx5IGFuZCBwb3NzaWJseSBjb3JydXB0ZWQgc2hhcmVkCm1lbW9yeS4NCjIwMjMtMDItMTQgMDk6 MTc6MzEuNDQ2IFVUQyBbMzJdIEhJTlQ6ICBJbiBhIG1vbWVudCB5b3Ugc2hvdWxkIGJlIGFibGUg dG8KcmVjb25uZWN0IHRvIHRoZSBkYXRhYmFzZSBhbmQgcmVwZWF0IHlvdXIgY29tbWFuZC4NCjIw MjMtMDItMTQgMDk6MTc6MzEuNDYxIFVUQyBbMzddIEZBVEFMOiAgdGhlIGRhdGFiYXNlIHN5c3Rl bSBpcyBpbiByZWNvdmVyeQptb2RlDQoyMDIzLTAyLTE0IDA5OjE3OjMxLjUyMiBVVEMgWzFdIExP RzogIGFsbCBzZXJ2ZXIgcHJvY2Vzc2VzIHRlcm1pbmF0ZWQ7CnJlaW5pdGlhbGl6aW5nDQoyMDIz LTAyLTE0IDA5OjE3OjMxLjU0NiBVVEMgWzM4XSBMT0c6ICBkYXRhYmFzZSBzeXN0ZW0gd2FzIGlu dGVycnVwdGVkOyBsYXN0Cmtub3duIHVwIGF0IDIwMjMtMDItMTQgMDk6MTY6MDUgVVRDDQoyMDIz LTAyLTE0IDA5OjE3OjMxLjc3OSBVVEMgWzM4XSBMT0c6ICBkYXRhYmFzZSBzeXN0ZW0gd2FzIG5v dCBwcm9wZXJseSBzaHV0CmRvd247IGF1dG9tYXRpYyByZWNvdmVyeSBpbiBwcm9ncmVzcw0KMjAy My0wMi0xNCAwOToxNzozMS43ODEgVVRDIFszOF0gTE9HOiAgcmVkbyBzdGFydHMgYXQgMC8xNUQ3 MDcwDQoyMDIzLTAyLTE0IDA5OjE3OjMxLjc4MiBVVEMgWzM4XSBMT0c6ICBpbnZhbGlkIHJlY29y ZCBsZW5ndGggYXQgMC8xNUQ3MEE4Ogp3YW50ZWQgMjQsIGdvdCAwDQoyMDIzLTAyLTE0IDA5OjE3 OjMxLjc4MiBVVEMgWzM4XSBMT0c6ICByZWRvIGRvbmUgYXQgMC8xNUQ3MDcwDQoyMDIzLTAyLTE0 IDA5OjE3OjMxLjc5MSBVVEMgWzFdIExPRzogIGRhdGFiYXNlIHN5c3RlbSBpcyByZWFkeSB0byBh Y2NlcHQKY29ubmVjdGlvbnMNCg0KSXQgbG9va3MgbGlrZSB0aGUgT1MgaXMga2lsbGluZyB0aGUg cHJvY2VzcyBkdWUgdG8gcnVubmluZyBPT00sIHdoaWNoIGlzIG5vdAp2ZXJ5IHN1cnByaXNpbmcg d2hlbiBsb29raW5nIGF0IHRoZSBxdWVyeS4gSXMgdGhpcyBleHBlY3RlZCwgb3Igc2hvdWxkIFBH CmhhdmUgZ3VhcmRzIGluIHBsYWNlIHRvIHByZXZlbnQgdGhpcyBmcm9tIGhhcHBlbmluZz8NCg0K SSBjb3VsZCByZXByb2R1Y2UgaXQgdXNpbmcgYSBmcmVzaCBkb2NrZXIgY29udGFpbmVyIG9mIHRo ZSBpbWFnZQoicG9zdGdyZXM6MTMuMTAiLg0KU0VMRUNUIHZlcnNpb24oKTsNCj4gUG9zdGdyZVNR TCAxMy4xMCAoRGViaWFuIDEzLjEwLTEucGdkZzExMCsxKSBvbiBhYXJjaDY0LXVua25vd24tbGlu dXgtZ251LApjb21waWxlZCBieSBnY2MgKERlYmlhbiAxMC4yLjEtNikgMTAuMi4xIDIwMjEwMTEw LCA2NC1iaXQKCg== --===============5622634889178154547==--