Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rWmJa-007AZ0-1T for pgsql-bugs@arkaria.postgresql.org; Sun, 04 Feb 2024 23:54:23 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rWmJY-009HXU-Sk for pgsql-bugs@arkaria.postgresql.org; Sun, 04 Feb 2024 23:54:20 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rWjDj-008FM3-O3 for pgsql-bugs@lists.postgresql.org; Sun, 04 Feb 2024 20:36:07 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rWjDh-00558h-2q for pgsql-bugs@lists.postgresql.org; Sun, 04 Feb 2024 20:36:06 +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=zDS3Owp+ao5w5FwutkHbacwml22bcAug8vt+WWhLjXo=; b=FvP7N//fTKSwfGfzIiJttyGcDp 4cm84qVnXdh0t6wqE4tsjVTu+HbvYmhnGb2Me5IP4KUDp8tQ+ZUVxF/xlcawLxV5dXpIYgLSP0LzH +DxM23xw/zQMKTVAzSpV1AFMXz21M2AB2m/cjtiTa5PvIKWBPof+dKKCkMQGUf1t3efNRdJRgppeg mXueMwG5sqAzbsNPOCid2tNMPemC6Niv9YpJ+2JFk4EPH2febHhN8C/bXuRw7QaqZ4LP9/BvRPaS7 DYfIPj9FTxEsdMYCxopkyy5UAhFan6F9xXf7C3A471cpA8qBBjMxN+AHkqBrr7q5OG4oI4JA6+pvH lIgNYCLg==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rWjDg-00FC88-5m for pgsql-bugs@lists.postgresql.org; Sun, 04 Feb 2024 20:36: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 1rWjDe-00H9hM-I3 for pgsql-bugs@lists.postgresql.org; Sun, 04 Feb 2024 20:36:02 +0000 Content-Type: multipart/mixed; boundary="===============4635577614980423537==" MIME-Version: 1.0 Subject: BUG #18330: The query planner chooses the wrong plan when using the parallel aggregation function To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: efremov20081@gmail.com Reply-To: efremov20081@gmail.com, pgsql-bugs@lists.postgresql.org Date: Sun, 04 Feb 2024 20:35:02 +0000 Message-ID: <18330-1823d6d59e6936c3@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 --===============4635577614980423537== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODMzMApMb2dnZWQgYnk6ICAgICAgICAgIE1pY2hhZWwgRWZyZW1vdgpF bWFpbCBhZGRyZXNzOiAgICAgIGVmcmVtb3YyMDA4MUBnbWFpbC5jb20KUG9zdGdyZVNRTCB2ZXJz aW9uOiAxNS4xCk9wZXJhdGluZyBzeXN0ZW06ICAgQWxwaW5lIDEyLjIuMV9naXQyMDIyMDkyNC1y NApEZXNjcmlwdGlvbjogICAgICAgIAoKQmVsb3cgaXMgYW4gZXhhbXBsZSBvZiBxdWVyaWVzLiBJ dCBzaG93cyB0aGF0IHRoZSBxdWVyeSBwbGFubmVyIGNob29zZXMKc2VxdWVudGlhbCBhZ2dyZWdh dGlvbiBpbnN0ZWFkIG9mIHBhcmFsbGVsLCBhbHRob3VnaCBsaW1pdCBzaG91bGQgbm90IGhhdmUK YWZmZWN0ZWQgdGhpcy4NCg0KLS0gRklSU1RMWSAtIGNyZWF0ZSBwYXJhbGxlbCBhZ2cgZnVuY3Rp b24NCg0KQ1JFQVRFIFRZUEUgdG9wMV91bml0c193ZWlnaHRzX3N0YXRlX3YxX3BhcmFsbGVsIEFT ICgNCiAgdGVzdCBqc29uYg0KKTsNCg0KQ1JFQVRFIE9SIFJFUExBQ0UgRlVOQ1RJT04gYWdnX3Rv cDFfdW5pdHNfd2VpZ2h0c190cmFuc2l0aW9uX3YxX3BhcmFsbGVsKA0KICBzdGF0ZSB0b3AxX3Vu aXRzX3dlaWdodHNfc3RhdGVfdjFfcGFyYWxsZWwsDQogIHRlc3QganNvbmINCikgUkVUVVJOUyB0 b3AxX3VuaXRzX3dlaWdodHNfc3RhdGVfdjFfcGFyYWxsZWwgQVMgJCQNCmJlZ2luDQogIFJFVFVS TiBzdGF0ZTsNCkVORDsNCiQkIExBTkdVQUdFIHBscGdzcWw7DQoNCg0KQ1JFQVRFIE9SIFJFUExB Q0UgRlVOQ1RJT04gYWdnX3RvcDFfdW5pdHNfd2VpZ2h0c19maW5hbF92MV9wYXJhbGxlbCgNCiAg c3RhdGUgdG9wMV91bml0c193ZWlnaHRzX3N0YXRlX3YxX3BhcmFsbGVsDQopIFJFVFVSTlMgdG9w MV91bml0c193ZWlnaHRzX3N0YXRlX3YxX3BhcmFsbGVsIEFTICQkDQpiZWdpbg0KICBSQUlTRSBO T1RJQ0UgJ2FnZ190b3AxX3VuaXRzX3dlaWdodHNfZmluYWxfdjFfcGFyYWxsZWw6JSAnLCBzdGF0 ZTsNCiAgUkVUVVJOIHN0YXRlOw0KRU5EOw0KJCQgTEFOR1VBR0UgcGxwZ3NxbDsNCg0KQ1JFQVRF IE9SIFJFUExBQ0UgRlVOQ1RJT04gYWdnX3RvcDFfdW5pdHNfd2VpZ2h0c19jb21iaW5lZnVuY192 MV9wYXJhbGxlbCgNCiAgZmlyc3QgdG9wMV91bml0c193ZWlnaHRzX3N0YXRlX3YxX3BhcmFsbGVs LA0KICBzZWNvbmQgdG9wMV91bml0c193ZWlnaHRzX3N0YXRlX3YxX3BhcmFsbGVsDQopIFJFVFVS TlMgdG9wMV91bml0c193ZWlnaHRzX3N0YXRlX3YxX3BhcmFsbGVsIEFTICQkDQpiZWdpbg0KUkFJ U0UgTk9USUNFICdhZ2dfdG9wMV91bml0c193ZWlnaHRzX2NvbWJpbmVmdW5jX3YxX3BhcmFsbGVs OiUgJywgZmlyc3Q7DQogIFJFVFVSTiBmaXJzdDsNCkVORDsNCiQkIExBTkdVQUdFIHBscGdzcWwg UEFSQUxMRUwgU0FGRTsNCg0KQ1JFQVRFIE9SIFJFUExBQ0UgQUdHUkVHQVRFIGFnZ190b3AxX3Vu aXRzX3dlaWdodHNfdjFfcGFyYWxsZWwoanNvbmIpICgNCiAgc2Z1bmMgICAgICAgPSBhZ2dfdG9w MV91bml0c193ZWlnaHRzX3RyYW5zaXRpb25fdjFfcGFyYWxsZWwsDQogIHN0eXBlICAgICAgID0g dG9wMV91bml0c193ZWlnaHRzX3N0YXRlX3YxX3BhcmFsbGVsLA0KICBmaW5hbGZ1bmMgICA9IGFn Z190b3AxX3VuaXRzX3dlaWdodHNfZmluYWxfdjFfcGFyYWxsZWwsDQogIGluaXRjb25kICAgID0g Jyh7fSknLA0KICBDT01CSU5FRlVOQyA9IGFnZ190b3AxX3VuaXRzX3dlaWdodHNfY29tYmluZWZ1 bmNfdjFfcGFyYWxsZWwsIA0KICBwYXJhbGxlbCAgICA9IFNBRkUgIA0KKTsNCg0KLS0gU0VDT05E TFkgLSBjcmVhdGUgdGVzdCBkYXRhDQoNCg0KQ1JFQVRFIFRBQkxFIHB1YmxpYy50ZXN0X2pzb25i X2FnZygNCgl0ZXN0X2pzb25iIGpzb25iIG5vdCBudWxsDQopOw0KDQpDUkVBVEUgT1IgUkVQTEFD RSBGVU5DVElPTiByYW5kb21fYmV0d2Vlbihsb3cgSU5UICxoaWdoIElOVCkNCiAgIFJFVFVSTlMg SU5UIEFTDQokJA0KQkVHSU4NCiAgIFJFVFVSTiBmbG9vcihyYW5kb20oKSogKGhpZ2gtbG93ICsg MSkgKyBsb3cpOw0KRU5EOw0KDQpDUkVBVEUgT1IgUkVQTEFDRSBGVU5DVElPTiByYW5kb21faW50 X2FycmF5KGRpbSBpbnRlZ2VyLCBtaW4gaW50ZWdlciwgbWF4CmludGVnZXIpIFJFVFVSTlMgaW50 ZWdlcltdIEFTICRCT0RZJA0KYmVnaW4NCglyZXR1cm4gKHNlbGVjdCBhcnJheV9hZ2cocmFuZG9t X2JldHdlZW4obWluLG1heCkpIGZyb20gZ2VuZXJhdGVfc2VyaWVzICgwLApkaW0pKTsNCmVuZA0K JEJPRFkkIExBTkdVQUdFIHBscGdzcWw7DQoNCkNSRUFURSBPUiBSRVBMQUNFIEZVTkNUSU9OIHJh bmRvbV9qc29uYl9hcnJheV9vZl9hcnJheShkaW0gaW50ZWdlciwgbWluCmludGVnZXIsIG1heCBp bnRlZ2VyKSBSRVRVUk5TIGpzb25iIEFTICRCT0RZJA0KZGVjbGFyZQ0KIHJlcyBqc29uYiA9ICdb XSc6Ompzb25iOw0KIGNudCBpbnRlZ2VyID0gcmFuZG9tX2JldHdlZW4oMSw0KTsNCmJlZ2luDQps b29wDQoJIHJlcyA9IGpzb25iX2J1aWxkX2FycmF5KHJhbmRvbV9pbnRfYXJyYXkoZGltLG1pbixt YXgpKSB8fCByZXM7DQogICAgSUYgY250ID4gMyBUSEVODQogICAgICAgIHJldHVybiByZXM7DQog ICAgRU5EIElGOw0KICAgIGNudCA9IGNudCArIDE7DQpFTkQgTE9PUDsNCmVuZA0KJEJPRFkkIExB TkdVQUdFIHBscGdzcWw7DQoNCklOU0VSVCBpbnRvIHRlc3RfanNvbmJfYWdnDQpzZWxlY3QNCglq c29uYl9hcnJheSBhcyBqc29uYl9hcnJheQ0KZnJvbSAoDQpzZWxlY3QNCiAgICByYW5kb21fanNv bmJfYXJyYXlfb2ZfYXJyYXkocmFuZG9tX2JldHdlZW4oMSw1KSwgMSwgNTAwKSBhcwpqc29uYl9h cnJheQ0KZnJvbSBnZW5lcmF0ZV9zZXJpZXMoMCwxMDAwMDApDQopIGFzIGRhdGFfdA0KDQotLSBU SElSRExZIC0gY2hlY2sgdHdvIHRpbWVzDQphbmFseXplIHRlc3RfanNvbmI7DQoNCmV4cGxhaW4g KGFuYWx5emUsdmVyYm9zZSx0aW1pbmcsY29zdHMsYnVmZmVycykNCndpdGggdGVzdF9zcGVlZCBh cyBub3QgTUFURVJJQUxJWkVEKA0Kc2VsZWN0IHRlc3RfanNvbmIgYXMgY29sDQpmcm9tIHRlc3Rf anNvbmJfYWdnICAtLSB0YWJsZSBzaXplIGlzIDEwMF8wMDANCmxpbWl0IDkwMDAwMCAtLSB0cnkg dG8gY29tbWVudCB0aGlzIGxpbmUgdGhlbiBwYXJhbGxlbCBhZ2dyZWdhdGlvbiBwbGFuIHdpbGwK YmUgdXNlZC4gDQopIHNlbGVjdCBhZ2dfdG9wMV91bml0c193ZWlnaHRzX3YxX3BhcmFsbGVsKGNv bCkNCmZyb20gdGVzdF9zcGVlZA0KDQotPiBvdXRwdXQNCkFnZ3JlZ2F0ZSAgKGNvc3Q9MjkxNzQu NTIuLjI5MTc0LjUzIHJvd3M9MSB3aWR0aD0zMikgKGFjdHVhbAp0aW1lPTUwLjg3Mi4uNTAuODcy IHJvd3M9MSBsb29wcz0xKQ0KICBPdXRwdXQ6IGFnZ190b3AxX3VuaXRzX3dlaWdodHNfdjFfcGFy YWxsZWwodGVzdF9qc29uYl9hZ2cudGVzdF9qc29uYikNCiAgQnVmZmVyczogc2hhcmVkIGhpdD0y MTc0DQogIC0+ICBMaW1pdCAgKGNvc3Q9MC4wMC4uMzE3NC4wMSByb3dzPTEwMDAwMSB3aWR0aD0x NDUpIChhY3R1YWwKdGltZT0wLjAwNy4uMTAuNDEyIHJvd3M9MTAwMDAxIGxvb3BzPTEpDQogICAg ICAgIE91dHB1dDogdGVzdF9qc29uYl9hZ2cudGVzdF9qc29uYg0KICAgICAgICBCdWZmZXJzOiBz aGFyZWQgaGl0PTIxNzQNCiAgICAgICAgLT4gIFNlcSBTY2FuIG9uIHB1YmxpYy50ZXN0X2pzb25i X2FnZyAgKGNvc3Q9MC4wMC4uMzE3NC4wMQpyb3dzPTEwMDAwMSB3aWR0aD0xNDUpIChhY3R1YWwg dGltZT0wLjAwNy4uNC45Mjggcm93cz0xMDAwMDEgbG9vcHM9MSkNCiAgICAgICAgICAgICAgT3V0 cHV0OiB0ZXN0X2pzb25iX2FnZy50ZXN0X2pzb25iDQogICAgICAgICAgICAgIEJ1ZmZlcnM6IHNo YXJlZCBoaXQ9MjE3NA0KUXVlcnkgSWRlbnRpZmllcjogODc0MTY3MDYzMDE2ODkxMDgxMQ0KUGxh bm5pbmcgVGltZTogMC4wNTEgbXMNCkV4ZWN1dGlvbiBUaW1lOiA1MC45MjAgbXMNCg0KZXhwbGFp biAoYW5hbHl6ZSx2ZXJib3NlLHRpbWluZyxjb3N0cyxidWZmZXJzKQ0Kd2l0aCB0ZXN0X3NwZWVk IGFzIG5vdCBNQVRFUklBTElaRUQoDQpzZWxlY3QgdGVzdF9qc29uYiBhcyBjb2wNCmZyb20gdGVz dF9qc29uYl9hZ2cgIC0tIHRhYmxlIHNpemUgaXMgMTAwXzAwMA0KLS1saW1pdCA5MDAwMDAgLS0g dHJ5IHRvIGNvbW1lbnQgdGhpcyBsaW5lIHRoZW4gcGFyYWxsZWwgYWdncmVnYXRpb24gcGxhbgp3 aWxsIGJlIHVzZWQuIA0KKSBzZWxlY3QgYWdnX3RvcDFfdW5pdHNfd2VpZ2h0c192MV9wYXJhbGxl bChjb2wpDQpmcm9tIHRlc3Rfc3BlZWQNCg0KLT4gb3V0cHV0DQpGaW5hbGl6ZSBBZ2dyZWdhdGUg IChjb3N0PTE0MDA4LjM4Li4xNDAwOC4zOSByb3dzPTEgd2lkdGg9MzIpIChhY3R1YWwKdGltZT0y OC43NzcuLjMyLjY2NCByb3dzPTEgbG9vcHM9MSkNCiAgT3V0cHV0OiBhZ2dfdG9wMV91bml0c193 ZWlnaHRzX3YxX3BhcmFsbGVsKHRlc3RfanNvbmJfYWdnLnRlc3RfanNvbmIpDQogIEJ1ZmZlcnM6 IHNoYXJlZCBoaXQ9MjM2NA0KICAtPiAgR2F0aGVyICAoY29zdD0xNDAwNy40Mi4uMTQwMDcuNjMg cm93cz0yIHdpZHRoPTMyKSAoYWN0dWFsCnRpbWU9MjguNjE5Li4zMi41MDggcm93cz0zIGxvb3Bz PTEpDQogICAgICAgIE91dHB1dDogKFBBUlRJQUwKYWdnX3RvcDFfdW5pdHNfd2VpZ2h0c192MV9w YXJhbGxlbCh0ZXN0X2pzb25iX2FnZy50ZXN0X2pzb25iKSkNCiAgICAgICAgV29ya2VycyBQbGFu bmVkOiAyDQogICAgICAgIFdvcmtlcnMgTGF1bmNoZWQ6IDINCiAgICAgICAgQnVmZmVyczogc2hh cmVkIGhpdD0yMzY0DQogICAgICAgIC0+ICBQYXJ0aWFsIEFnZ3JlZ2F0ZSAgKGNvc3Q9MTMwMDcu NDIuLjEzMDA3LjQzIHJvd3M9MSB3aWR0aD0zMikKKGFjdHVhbCB0aW1lPTE1LjU2Ny4uMTUuNTY4 IHJvd3M9MSBsb29wcz0zKQ0KICAgICAgICAgICAgICBPdXRwdXQ6IFBBUlRJQUwKYWdnX3RvcDFf dW5pdHNfd2VpZ2h0c192MV9wYXJhbGxlbCh0ZXN0X2pzb25iX2FnZy50ZXN0X2pzb25iKQ0KICAg ICAgICAgICAgICBCdWZmZXJzOiBzaGFyZWQgaGl0PTIzNjQNCiAgICAgICAgICAgICAgV29ya2Vy IDA6ICBhY3R1YWwgdGltZT05LjE5Ny4uOS4xOTggcm93cz0xIGxvb3BzPTENCiAgICAgICAgICAg ICAgICBCdWZmZXJzOiBzaGFyZWQgaGl0PTUwMQ0KICAgICAgICAgICAgICBXb3JrZXIgMTogIGFj dHVhbCB0aW1lPTkuMjAxLi45LjIwMiByb3dzPTEgbG9vcHM9MQ0KICAgICAgICAgICAgICAgIEJ1 ZmZlcnM6IHNoYXJlZCBoaXQ9NTIwDQogICAgICAgICAgICAgIC0+ICBQYXJhbGxlbCBTZXEgU2Nh biBvbiBwdWJsaWMudGVzdF9qc29uYl9hZ2cgCihjb3N0PTAuMDAuLjI1OTAuNjcgcm93cz00MTY2 NyB3aWR0aD0xNDUpIChhY3R1YWwgdGltZT0wLjAwOC4uMS44NzIKcm93cz0zMzMzNCBsb29wcz0z KQ0KICAgICAgICAgICAgICAgICAgICBPdXRwdXQ6IHRlc3RfanNvbmJfYWdnLnRlc3RfanNvbmIN CiAgICAgICAgICAgICAgICAgICAgQnVmZmVyczogc2hhcmVkIGhpdD0yMTc0DQogICAgICAgICAg ICAgICAgICAgIFdvcmtlciAwOiAgYWN0dWFsIHRpbWU9MC4wMDkuLjEuMTk1IHJvd3M9MTg2MTIg bG9vcHM9MQ0KICAgICAgICAgICAgICAgICAgICAgIEJ1ZmZlcnM6IHNoYXJlZCBoaXQ9NDA2DQog ICAgICAgICAgICAgICAgICAgIFdvcmtlciAxOiAgYWN0dWFsIHRpbWU9MC4wMDkuLjEuMjA1IHJv d3M9MTk0NjIgbG9vcHM9MQ0KICAgICAgICAgICAgICAgICAgICAgIEJ1ZmZlcnM6IHNoYXJlZCBo aXQ9NDI1DQpRdWVyeSBJZGVudGlmaWVyOiA0MzY4ODE4OTI1MDUzMjg0NDQwDQpQbGFubmluZyBU aW1lOiAwLjA1NCBtcw0KRXhlY3V0aW9uIFRpbWU6IDMyLjcxOCBtcwoK --===============4635577614980423537==--