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 1oMPoM-00065z-Gz for pgsql-bugs@arkaria.postgresql.org; Fri, 12 Aug 2022 08:14:30 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oMPoL-0002Hd-Fp for pgsql-bugs@arkaria.postgresql.org; Fri, 12 Aug 2022 08:14:29 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oMO6W-0005qo-8k for pgsql-bugs@lists.postgresql.org; Fri, 12 Aug 2022 06:25:08 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oMO6T-0003uP-Sy for pgsql-bugs@lists.postgresql.org; Fri, 12 Aug 2022 06:25:07 +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=WyUIx1FJB66QSWGU6ZtoLTtoFnFgHC+GWHVRXDyOyYk=; b=S3cTgkScSP/uPVir1mOivFUKE2 UyUs0sir7ZQEhPe7NL/LFHJAgq7XaU45hmc2g/GKr88Hn+q9D0KHeT8H6pmwGUVbg3L551KjJ4v6P K6tDweaMkOFk0Lli57FM8blwBt+KcQ6YCEaYInwGwblDUqT5OEvhsZVR+zTR12dWhuc6kWt9xnq1f P3nCmw7wTygTFPWOs2qaxoXanY4zHWsUb6AX9QfeYPAMTZ8DnQa+R7mJA9wu52KP8EDJWujCrY09N JmK0U3HiyIGwBTREHvFFC9Xt2cjLrhbqfj1CdnYLmegoTQXDXYGXX3yVn202RRkoND8KDhxXgjfGe /AM6mBDA==; 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 1oMO6S-0006y4-Kh for pgsql-bugs@lists.postgresql.org; Fri, 12 Aug 2022 06:25:05 +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 1oMO6Q-005qbb-MN for pgsql-bugs@lists.postgresql.org; Fri, 12 Aug 2022 06:25:02 +0000 Content-Type: multipart/mixed; boundary="===============3100323168735127701==" MIME-Version: 1.0 Subject: BUG #17583: Server crashes on executing CROSS JOIN with very big number of tables To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: kyzevan23@mail.ru Reply-To: kyzevan23@mail.ru, pgsql-bugs@lists.postgresql.org Date: Fri, 12 Aug 2022 06:24:55 +0000 Message-ID: <17583-33be55b9f981f75c@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 --===============3100323168735127701== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzU4MwpMb2dnZWQgYnk6ICAgICAgICAgIEVnb3IgQ2hpbmR5YXNraW4K RW1haWwgYWRkcmVzczogICAgICBreXpldmFuMjNAbWFpbC5ydQpQb3N0Z3JlU1FMIHZlcnNpb246 IDE0LjUKT3BlcmF0aW5nIHN5c3RlbTogICBVYnVudHUgMjIuMDQKRGVzY3JpcHRpb246ICAgICAg ICAKCkkgZ290IHNlcnZlciBjcmFzaGVkIHdoaWxlIGV4ZWN1dGluZyB0aGUgZm9sbG93aW5nIHF1 ZXJ5OiANCihlY2hvICJTRUxFQ1QgKiBGUk9NIHQxICI7Zm9yKChpPTI7aTwxMDAwMDA7aSsrKSk7 ZG8gZWNobyAiQ1JPU1MgSk9JTiB0JGkKIjtkb25lOyBlY2hvICI7IikgfCBwc3FsDQp3aXRoIHRo ZSBmb2xsb3dpbmcgYmFja3RyYWNlIGJlbG93OiANCkNvcmUgd2FzIGdlbmVyYXRlZCBieSBgcG9z dGdyZXM6IGVnb3JjaGluIGVnb3JjaGluIFtsb2NhbF0gU0VMRUNUICAgICAgICAgICAKICAgICAg ICAgICAgJy4NClByb2dyYW0gdGVybWluYXRlZCB3aXRoIHNpZ25hbCBTSUdTRUdWLCBTZWdtZW50 YXRpb24gZmF1bHQuDQojMCAgMHgwMDAwNTVmM2EzYmNiZjdmIGluIHRyYW5zZm9ybUZyb21DbGF1 c2VJdGVtCihwc3RhdGU9cHN0YXRlQGVudHJ5PTB4N2ZlMWM3MDg1YTA4LCBuPTB4N2ZlMWM3OGY5 YTM4LAp0b3BfbnNpdGVtPXRvcF9uc2l0ZW1AZW50cnk9MHg3ZmZlNDAwOTYwZDgsCm5hbWVzcGFj ZT1uYW1lc3BhY2VAZW50cnk9MHg3ZmZlNDAwOTYwZTgpIGF0IHBhcnNlX2NsYXVzZS5jOjEwNTYN CjEwNTYJcGFyc2VfY2xhdXNlLmM6IE5vIHN1Y2ggZmlsZSBvciBkaXJlY3RvcnkuDQooZ2RiKSBi dA0KIzAgIDB4MDAwMDU1ZjNhM2JjYmY3ZiBpbiB0cmFuc2Zvcm1Gcm9tQ2xhdXNlSXRlbQoocHN0 YXRlPXBzdGF0ZUBlbnRyeT0weDdmZTFjNzA4NWEwOCwgbj0weDdmZTFjNzhmOWEzOCwKdG9wX25z aXRlbT10b3BfbnNpdGVtQGVudHJ5PTB4N2ZmZTQwMDk2MGQ4LApuYW1lc3BhY2U9bmFtZXNwYWNl QGVudHJ5PTB4N2ZmZTQwMDk2MGU4KSBhdCBwYXJzZV9jbGF1c2UuYzoxMDU2DQojMSAgMHgwMDAw NTVmM2EzYmNjMDE0IGluIHRyYW5zZm9ybUZyb21DbGF1c2VJdGVtCihwc3RhdGU9cHN0YXRlQGVu dHJ5PTB4N2ZlMWM3MDg1YTA4LCBuPTB4N2ZlMWM3OGY5YjQ4LAp0b3BfbnNpdGVtPXRvcF9uc2l0 ZW1AZW50cnk9MHg3ZmZlNDAwOTYxZjgsCm5hbWVzcGFjZT1uYW1lc3BhY2VAZW50cnk9MHg3ZmZl NDAwOTYyMDgpIGF0IHBhcnNlX2NsYXVzZS5jOjExNjkNCiMyICAweDAwMDA1NWYzYTNiY2MwMTQg aW4gdHJhbnNmb3JtRnJvbUNsYXVzZUl0ZW0KKHBzdGF0ZT1wc3RhdGVAZW50cnk9MHg3ZmUxYzcw ODVhMDgsIG49MHg3ZmUxYzc4ZjljNTgsCnRvcF9uc2l0ZW09dG9wX25zaXRlbUBlbnRyeT0weDdm ZmU0MDA5NjMxOCwKbmFtZXNwYWNlPW5hbWVzcGFjZUBlbnRyeT0weDdmZmU0MDA5NjMyOCkgYXQg cGFyc2VfY2xhdXNlLmM6MTE2OQ0KIzMgIDB4MDAwMDU1ZjNhM2JjYzAxNCBpbiB0cmFuc2Zvcm1G cm9tQ2xhdXNlSXRlbQoocHN0YXRlPXBzdGF0ZUBlbnRyeT0weDdmZTFjNzA4NWEwOCwgbj0weDdm ZTFjNzhmOWQ2OCwKdG9wX25zaXRlbT10b3BfbnNpdGVtQGVudHJ5PTB4N2ZmZTQwMDk2NDM4LApu YW1lc3BhY2U9bmFtZXNwYWNlQGVudHJ5PTB4N2ZmZTQwMDk2NDQ4KSBhdCBwYXJzZV9jbGF1c2Uu YzoxMTY5DQouLi4NCiMyOTEwNiAweDAwMDA1NWYzYTNiY2MwMTQgaW4gdHJhbnNmb3JtRnJvbUNs YXVzZUl0ZW0KKHBzdGF0ZT1wc3RhdGVAZW50cnk9MHg3ZmUxYzcwODVhMDgsIG49MHg3ZmUxYzcw ODU3ODAsCnRvcF9uc2l0ZW09dG9wX25zaXRlbUBlbnRyeT0weDdmZmU0MDg5NDg4OCwKbmFtZXNw YWNlPW5hbWVzcGFjZUBlbnRyeT0weDdmZmU0MDg5NDg5MCkgYXQgcGFyc2VfY2xhdXNlLmM6MTE2 OQ0KIzI5MTA3IDB4MDAwMDU1ZjNhM2JjY2U2YiBpbiB0cmFuc2Zvcm1Gcm9tQ2xhdXNlCihwc3Rh dGU9cHN0YXRlQGVudHJ5PTB4N2ZlMWM3MDg1YTA4LCBmcm1MaXN0PTB4N2ZlMWM3MDg1ODE4KSBh dApwYXJzZV9jbGF1c2UuYzoxMzINCiMyOTEwOCAweDAwMDA1NWYzYTNiYWM2YWYgaW4gdHJhbnNm b3JtU2VsZWN0U3RtdCAocHN0YXRlPTB4N2ZlMWM3MDg1YTA4LApzdG10PXN0bXRAZW50cnk9MHg3 ZmUxYzcwODU4OTgpIGF0IGFuYWx5emUuYzoxMjcwDQojMjkxMDkgMHgwMDAwNTVmM2EzYmFkMTgx IGluIHRyYW5zZm9ybVN0bXQKKHBzdGF0ZT1wc3RhdGVAZW50cnk9MHg3ZmUxYzcwODVhMDgsCnBh cnNlVHJlZT1wYXJzZVRyZWVAZW50cnk9MHg3ZmUxYzcwODU4OTgpIGF0IGFuYWx5emUuYzozMjMN CiMyOTExMCAweDAwMDA1NWYzYTNiYWU0NDIgaW4gdHJhbnNmb3JtT3B0aW9uYWxTZWxlY3RJbnRv Cihwc3RhdGU9cHN0YXRlQGVudHJ5PTB4N2ZlMWM3MDg1YTA4LCBwYXJzZVRyZWU9MHg3ZmUxYzcw ODU4OTgpIGF0CmFuYWx5emUuYzoyNjgNCiMyOTExMSAweDAwMDA1NWYzYTNiYWU0NzcgaW4gdHJh bnNmb3JtVG9wTGV2ZWxTdG10Cihwc3RhdGU9cHN0YXRlQGVudHJ5PTB4N2ZlMWM3MDg1YTA4LApw YXJzZVRyZWU9cGFyc2VUcmVlQGVudHJ5PTB4N2ZlMWM4Njk1ZmYwKSBhdCBhbmFseXplLmM6MjE4 DQojMjkxMTIgMHgwMDAwNTVmM2EzYmFlNGRmIGluIHBhcnNlX2FuYWx5emUKKHBhcnNlVHJlZT1w YXJzZVRyZWVAZW50cnk9MHg3ZmUxYzg2OTVmZjAsCnNvdXJjZVRleHQ9c291cmNlVGV4dEBlbnRy eT0weDdmZTFjOTA0YjA1MCAiU0VMRUNUICogRlJPTSB0MSBcbkNST1NTIEpPSU4gdDIKXG5DUk9T UyBKT0lOIHQzIFxuQ1JPU1MgSk9JTiB0NCBcbkNST1NTIEpPSU4gdDUgXG5DUk9TUyBKT0lOIHQ2 IFxuQ1JPU1MgSk9JTgp0NyBcbkNST1NTIEpPSU4gdDggXG5DUk9TUyBKT0lOIHQ5IFxuQ1JPU1Mg Sk9JTiB0MTAgXG5DUk9TUyBKT0lOIHQxMSBcbkNST1NTCkpPSU4gdDEyIFxuQ1JPU1MgSk9JTiB0 MTMiLi4uLCBwYXJhbVR5cGVzPXBhcmFtVHlwZXNAZW50cnk9MHgwLApudW1QYXJhbXM9bnVtUGFy YW1zQGVudHJ5PTAsIHF1ZXJ5RW52PXF1ZXJ5RW52QGVudHJ5PTB4MCkgYXQgYW5hbHl6ZS5jOjEy Nw0KIzI5MTEzIDB4MDAwMDU1ZjNhM2U1YTZlOCBpbiBwZ19hbmFseXplX2FuZF9yZXdyaXRlCihw YXJzZXRyZWU9cGFyc2V0cmVlQGVudHJ5PTB4N2ZlMWM4Njk1ZmYwLApxdWVyeV9zdHJpbmc9cXVl cnlfc3RyaW5nQGVudHJ5PTB4N2ZlMWM5MDRiMDUwICJTRUxFQ1QgKiBGUk9NIHQxIFxuQ1JPU1MK Sk9JTiB0MiBcbkNST1NTIEpPSU4gdDMgXG5DUk9TUyBKT0lOIHQ0IFxuQ1JPU1MgSk9JTiB0NSBc bkNST1NTIEpPSU4gdDYKXG5DUk9TUyBKT0lOIHQ3IFxuQ1JPU1MgSk9JTiB0OCBcbkNST1NTIEpP SU4gdDkgXG5DUk9TUyBKT0lOIHQxMCBcbkNST1NTCkpPSU4gdDExIFxuQ1JPU1MgSk9JTiB0MTIg XG5DUk9TUyBKT0lOIHQxMyIuLi4sCnBhcmFtVHlwZXM9cGFyYW1UeXBlc0BlbnRyeT0weDAsIG51 bVBhcmFtcz1udW1QYXJhbXNAZW50cnk9MCwKcXVlcnlFbnY9cXVlcnlFbnZAZW50cnk9MHgwKSBh dCBwb3N0Z3Jlcy5jOjY1Ng0KIzI5MTE0IDB4MDAwMDU1ZjNhM2U1YWUyMSBpbiBleGVjX3NpbXBs ZV9xdWVyeQoocXVlcnlfc3RyaW5nPXF1ZXJ5X3N0cmluZ0BlbnRyeT0weDdmZTFjOTA0YjA1MCAi U0VMRUNUICogRlJPTSB0MSBcbkNST1NTCkpPSU4gdDIgXG5DUk9TUyBKT0lOIHQzIFxuQ1JPU1Mg Sk9JTiB0NCBcbkNST1NTIEpPSU4gdDUgXG5DUk9TUyBKT0lOIHQ2ClxuQ1JPU1MgSk9JTiB0NyBc bkNST1NTIEpPSU4gdDggXG5DUk9TUyBKT0lOIHQ5IFxuQ1JPU1MgSk9JTiB0MTAgXG5DUk9TUwpK T0lOIHQxMSBcbkNST1NTIEpPSU4gdDEyIFxuQ1JPU1MgSk9JTiB0MTMiLi4uKSBhdCBwb3N0Z3Jl cy5jOjExMjkNCiMyOTExNSAweDAwMDA1NWYzYTNlNWNlZWUgaW4gUG9zdGdyZXNNYWluIChhcmdj PWFyZ2NAZW50cnk9MSwKYXJndj1hcmd2QGVudHJ5PTB4N2ZmZTQwODk0YmUwLCBkYm5hbWU9PG9w dGltaXplZCBvdXQ+LCB1c2VybmFtZT08b3B0aW1pemVkCm91dD4pIGF0IHBvc3RncmVzLmM6NDQ5 Ng0KIzI5MTE2IDB4MDAwMDU1ZjNhM2RiNzI5MSBpbiBCYWNrZW5kUnVuIChwb3J0PXBvcnRAZW50 cnk9MHg1NWYzYTViZTcyNTApIGF0CnBvc3RtYXN0ZXIuYzo0NTMwDQojMjkxMTcgMHgwMDAwNTVm M2EzZGJhNTQ0IGluIEJhY2tlbmRTdGFydHVwIChwb3J0PXBvcnRAZW50cnk9MHg1NWYzYTViZTcy NTApCmF0IHBvc3RtYXN0ZXIuYzo0MjUyDQojMjkxMTggMHgwMDAwNTVmM2EzZGJhNzdkIGluIFNl cnZlckxvb3AgKCkgYXQgcG9zdG1hc3Rlci5jOjE3NDUNCiMyOTExOSAweDAwMDA1NWYzYTNkYmJj YzQgaW4gUG9zdG1hc3Rlck1haW4gKGFyZ2M9YXJnY0BlbnRyeT0zLAphcmd2PWFyZ3ZAZW50cnk9 MHg1NWYzYTViYmUzZDApIGF0IHBvc3RtYXN0ZXIuYzoxNDE3DQojMjkxMjAgMHgwMDAwNTVmM2Ez Y2ZjMTU2IGluIG1haW4gKGFyZ2M9MywgYXJndj0weDU1ZjNhNWJiZTNkMCkgYXQKbWFpbi5jOjIw OQoK --===============3100323168735127701==--