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 1qQvwh-0000vp-Hy for pgsql-hackers@arkaria.postgresql.org; Tue, 01 Aug 2023 20:26:19 +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 1qQvwg-0001Tu-2q for pgsql-hackers@arkaria.postgresql.org; Tue, 01 Aug 2023 20:26:18 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qQvwf-0001Tj-J2 for pgsql-hackers@lists.postgresql.org; Tue, 01 Aug 2023 20:26:18 +0000 Received: from smtp-fw-33001.amazon.com ([207.171.190.10]) by magus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qQvwZ-0000di-Kt for pgsql-hackers@postgresql.org; Tue, 01 Aug 2023 20:26:16 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=amazon.com; i=@amazon.com; q=dns/txt; s=amazon201209; t=1690921572; x=1722457572; h=from:to:cc:date:message-id:references:in-reply-to: content-id:content-transfer-encoding:mime-version:subject; bh=8exJtl+Zy1WMlzMwn+xPTXnsvqEJfU4QYyZo/+tMjXM=; b=R8gsAzmx8yeOZMX0d11swqPRRdFmfh9YiWp1VEJ/Y7rg947Y6LeKtOmL O4udBZ1Yk6lwlH2BSXQci8qU9tboOujFg2WzNOyYNoiTMfQqpJHemJJfo LVDJMrUs6SE2MkT/GjcEkJVY4lr8gDlP6BQrow+asyNEnusSX6Fde7bVu Y=; X-IronPort-AV: E=Sophos;i="6.01,248,1684800000"; d="scan'208";a="298171209" Subject: Re: Partial aggregates pushdown Thread-Topic: Partial aggregates pushdown Received: from iad12-co-svc-p1-lb1-vlan3.amazon.com (HELO email-inbound-relay-pdx-2b-m6i4x-f323d91c.us-west-2.amazon.com) ([10.43.8.6]) by smtp-border-fw-33001.sea14.amazon.com with ESMTP/TLS/ECDHE-RSA-AES256-GCM-SHA384; 01 Aug 2023 20:26:08 +0000 Received: from EX19MTAUEA002.ant.amazon.com (pdx1-ws-svc-p6-lb9-vlan3.pdx.amazon.com [10.236.137.198]) by email-inbound-relay-pdx-2b-m6i4x-f323d91c.us-west-2.amazon.com (Postfix) with ESMTPS id B69E640D5C; Tue, 1 Aug 2023 20:26:05 +0000 (UTC) Received: from EX19D009UEB001.ant.amazon.com (10.252.135.22) by EX19MTAUEA002.ant.amazon.com (10.252.134.9) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.2.1118.30; Tue, 1 Aug 2023 20:25:56 +0000 Received: from EX19D009UEB003.ant.amazon.com (10.252.135.64) by EX19D009UEB001.ant.amazon.com (10.252.135.22) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.2.1118.30; Tue, 1 Aug 2023 20:25:55 +0000 Received: from EX19D009UEB003.ant.amazon.com ([fe80::71d7:3fda:6f13:645a]) by EX19D009UEB003.ant.amazon.com ([fe80::71d7:3fda:6f13:645a%3]) with mapi id 15.02.1118.030; Tue, 1 Aug 2023 20:25:55 +0000 From: "Finnerty, Jim" To: Alexander Pyhalov , "Fujii.Yuki@df.MitsubishiElectric.co.jp" CC: Bruce Momjian , PostgreSQL-development , Andres Freund , Tom Lane , Tomas Vondra , "Julien Rouhaud" , Daniel Gustafsson , "Ilya Gladyshev" Thread-Index: AQHYPYasTfJpCf0a4028YJm7JfY5bazLVbIAgAA/QgCAzsLGAICupJqAgAOhGYCAC47OQIAAf6sAgAAdMNCAAEyGgIAAtjrAgAD/KACABTrjIIAEWzOAgAyCOHCApWPpgIAAT1AggArXpoCAAFPI0IABO+iAgAMFFICABR/vAIAACpQAgABDk4CAAU/RgIBJ2XYAgAgC/oCAAC5WgIAGnISAgAQxEbCAAFHVgIAA0HSAgArptoCAAGksgIACJPSAgADj/XCAAGn4AIAcBMuAgAawUACABWxaMIAA+1TAgALPZgCAE0EqAA== Date: Tue, 1 Aug 2023 20:25:55 +0000 Message-ID: <69F8631B-446A-42FB-ACF4-E70C7EF73205@amazon.com> References: <8ffedecae0d21a3cd93805baf1dcc0de@postgrespro.ru> <6893fbdcd63140179f4987b76edba95d@postgrespro.ru> In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [10.106.178.21] Content-Type: text/plain; charset="utf-8" Content-ID: Content-Transfer-Encoding: base64 MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk V2hlbiBpdCBpcyB2YWxpZCB0byBmaWx0ZXIgYmFzZWQgb24gYSBIQVZJTkcgY2xhdXNlIHByZWRp Y2F0ZSwgaXQgc2hvdWxkIGFscmVhZHkgaGF2ZSBiZWVuIGNvbnZlcnRlZCBpbnRvIGEgV0hFUkUg Y2xhdXNlIHByZWRpY2F0ZSwgZXhjZXB0IGluIHRoZSBzcGVjaWFsIGNhc2Ugb2YgYW4gTElNSVQg VE8gLmsgLi4gT1JERVIgQlkgY2FzZSB3aGVyZSB0aGUgSEFWSU5HIGNsYXVzZSBwcmVkaWNhdGUg Y2FuIGJlIGRldGVybWluZWQgYXBwcm94aW1hdGVseSBhZnRlciBoYXZpbmcgZm91bmQgayBmdWxs eSBxdWFsaWZpZWQgdHVwbGVzIGFuZCB0aGVuIHRoYXQgcHJlZGljYXRlIGlzIHN1Y2Nlc3NpdmVs eSB0aWdodGVuZWQgYXMgbW9yZSBxdWFsaWZpZWQgcmVjb3JkcyBhcmUgZm91bmQuDQoNCip0aGF0 KiwgYnkgdGhlIHdheSwgaXMgYSB2ZXJ5IHBvd2VyZnVsIG9wdGltaXphdGlvbi4NCg0KICAgIC9K aW0gRg0KDQrvu79PbiA3LzIwLzIzLCA2OjI0IEFNLCAiQWxleGFuZGVyIFB5aGFsb3YiIDxhLnB5 aGFsb3ZAcG9zdGdyZXNwcm8ucnUgPG1haWx0bzphLnB5aGFsb3ZAcG9zdGdyZXNwcm8ucnU+PiB3 cm90ZToNCg0KDQpDQVVUSU9OOiBUaGlzIGVtYWlsIG9yaWdpbmF0ZWQgZnJvbSBvdXRzaWRlIG9m IHRoZSBvcmdhbml6YXRpb24uIERvIG5vdCBjbGljayBsaW5rcyBvciBvcGVuIGF0dGFjaG1lbnRz IHVubGVzcyB5b3UgY2FuIGNvbmZpcm0gdGhlIHNlbmRlciBhbmQga25vdyB0aGUgY29udGVudCBp cyBzYWZlLg0KDQoNCg0KDQoNCg0KRnVqaWkuWXVraUBkZi5NaXRzdWJpc2hpRWxlY3RyaWMuY28u anAgPG1haWx0bzpGdWppaS5ZdWtpQGRmLk1pdHN1YmlzaGlFbGVjdHJpYy5jby5qcD4g0L/QuNGB 0LDQuyAyMDIzLTA3LTE5IDAzOjQzOg0KPiBIaSBNci5QeWhhbG92LCBoYWNrZXJzLg0KDQoNCj4g MykNCj4gSSBtb2RpZmllZCB0aGUgcGF0Y2ggdG8gc2FmZWx5IGRvIGEgcGFydGlhbCBhZ2dyZWdh dGUgcHVzaGRvd24gZm9yDQo+IHF1ZXJpZXMgd2hpY2ggY29udGFpbiBoYXZpbmcgY2xhdXNlcy4N Cj4NCg0KDQpIaS4NClNvcnJ5LCBidXQgSSBkb24ndCBzZWUgaG93IGl0IGNvdWxkIHdvcmsuDQpG b3IgZXhhbXBsZSwgdGhlIGF0dGFjaGVkIHRlc3QgcmV0dXJucyB3cm9uZyByZXN1bHQ6DQoNCg0K Q1JFQVRFIEZVTkNUSU9OIGYoKSBSRVRVUk5TIElOVCBBUyAkJA0KYmVnaW4NCnJldHVybiAxMDsN CmVuZA0KJCQgTEFOR1VBR0UgUExQR1NRTDsNCg0KDQpTRUxFQ1QgYiwgc3VtKGEpIEZST00gcGFn Z190YWIgR1JPVVAgQlkgYiBIQVZJTkcgc3VtKGEpIDwgZigpIE9SREVSIEJZDQoxOw0KYiB8IHN1 bQ0KLS0tLSstLS0tLQ0KMCB8IDANCjEwIHwgMA0KMjAgfCAwDQozMCB8IDANCjQwIHwgMA0KKyg1 IHJvd3MpDQoNCg0KSW4gZmFjdCB0aGUgYWJvdmUgcXVlcnkgc2hvdWxkIGhhdmUgcmV0dXJuZWQg MCByb3dzLCBhcw0KDQoNClNFTEVDVCBiLCBzdW0oYSkgRlJPTSBwYWdnX3RhYiBHUk9VUCBCWSBi IE9SREVSIEJZIDE7DQpiIHwgc3VtDQotLS0tKy0tLS0tLQ0KMCB8IDYwMA0KMSB8IDY2MA0KMiB8 IDcyMA0KMyB8IDc4MA0KNCB8IDg0MA0KNSB8IDkwMA0KNiB8IDk2MA0KNyB8IDEwMjANCjggfCAx MDgwDQo5IHwgMTE0MA0KMTAgfCA2MDANCjExIHwgNjYwDQoxMiB8IDcyMA0KLi4uLg0Kc2hvd3Mg bm8gc3VjaCByb3dzLg0KDQoNCk9yLCBvbiB0aGUgc2FtZSBkYXRhDQoNCg0KU0VMRUNUIGIsIHN1 bShhKSBGUk9NIHBhZ2dfdGFiIEdST1VQIEJZIGIgSEFWSU5HIHN1bShhKSA+IDY2MCBPUkRFUiBC WQ0KMTsNCg0KDQpZb3UnbGwgZ2V0IDAgcm93cy4NCg0KDQpCdXQNClNFTEVDVCBiLCBzdW0oYSkg RlJPTSBwYWdnX3RhYiBHUk9VUCBCWSBiOw0KYiB8IHN1bQ0KLS0tLSstLS0tLS0NCjQyIHwgNzIw DQoyOSB8IDExNDANCjQgfCA4NDANCjM0IHwgODQwDQo0MSB8IDY2MA0KMCB8IDYwMA0KNDAgfCA2 MDANCmdpdmVzLg0KDQoNClRoZSBpc3N1ZSBpcyB0aGF0IHlvdSBjYW4ndCBjYWxjdWxhdGUgInBh cnRpYWwiIGhhdmluZy4gWW91IHNob3VsZA0KY29tcGFyZSBmdWxsIGFnZ3JlZ2F0ZSBpbiBmaWx0 ZXIsIGJ1dCBpdCdzIG5vdCBwb3NzaWJsZSBvbiB0aGUgbGV2ZWwgb2YNCm9uZSBwYXJ0aXRpb24u DQpBbmQgeW91IGhhdmUgdGhpcyBpbiBwbGFucw0KDQoNCkZpbmFsaXplIEdyb3VwQWdncmVnYXRl DQpPdXRwdXQ6IHBhZ2dfdGFiLmIsIGF2ZyhwYWdnX3RhYi5hKSwgbWF4KHBhZ2dfdGFiLmEpLCBj b3VudCgqKQ0KR3JvdXAgS2V5OiBwYWdnX3RhYi5iDQpGaWx0ZXI6IChzdW0ocGFnZ190YWIuYSkg PCA3MDApDQotPiBTb3J0DQpPdXRwdXQ6IHBhZ2dfdGFiLmIsIChQQVJUSUFMIGF2ZyhwYWdnX3Rh Yi5hKSksIChQQVJUSUFMDQptYXgocGFnZ190YWIuYSkpLCAoUEFSVElBTCBjb3VudCgqKSksIChQ QVJUSUFMIHN1bShwYWdnX3RhYi5hKSkNClNvcnQgS2V5OiBwYWdnX3RhYi5iDQotPiBBcHBlbmQN Ci0+IEZvcmVpZ24gU2Nhbg0KT3V0cHV0OiBwYWdnX3RhYi5iLCAoUEFSVElBTCBhdmcocGFnZ190 YWIuYSkpLA0KKFBBUlRJQUwgbWF4KHBhZ2dfdGFiLmEpKSwgKFBBUlRJQUwgY291bnQoKikpLCAo UEFSVElBTCBzdW0ocGFnZ190YWIuYSkpDQpGaWx0ZXI6ICgoUEFSVElBTCBzdW0ocGFnZ190YWIu YSkpIDwgNzAwKSAhISEhDQo8LS0tIGhlcmUgd2UgY2FuJ3QgY29tcGFyZSBhbnl0aGluZyB5ZXQs IHN1bSBpcyBpbmNvbXBsZXRlLg0KUmVsYXRpb25zOiBBZ2dyZWdhdGUgb24gKHB1YmxpYy5mcGFn Z190YWJfcDENCnBhZ2dfdGFiKQ0KUmVtb3RlIFNRTDogU0VMRUNUIGIsIGF2Z19wX2ludDQoYSks IG1heChhKSwNCmNvdW50KCopLCBzdW0oYSkgRlJPTSBwdWJsaWMucGFnZ190YWJfcDEgR1JPVVAg QlkgMQ0KLT4gRm9yZWlnbiBTY2FuDQpPdXRwdXQ6IHBhZ2dfdGFiXzEuYiwgKFBBUlRJQUwgYXZn KHBhZ2dfdGFiXzEuYSkpLA0KKFBBUlRJQUwgbWF4KHBhZ2dfdGFiXzEuYSkpLCAoUEFSVElBTCBj b3VudCgqKSksIChQQVJUSUFMDQpzdW0ocGFnZ190YWJfMS5hKSkNCkZpbHRlcjogKChQQVJUSUFM IHN1bShwYWdnX3RhYl8xLmEpKSA8IDcwMCkNClJlbGF0aW9uczogQWdncmVnYXRlIG9uIChwdWJs aWMuZnBhZ2dfdGFiX3AyDQpwYWdnX3RhYl8xKQ0KUmVtb3RlIFNRTDogU0VMRUNUIGIsIGF2Z19w X2ludDQoYSksIG1heChhKSwNCmNvdW50KCopLCBzdW0oYSkgRlJPTSBwdWJsaWMucGFnZ190YWJf cDIgR1JPVVAgQlkgMQ0KLT4gRm9yZWlnbiBTY2FuDQpPdXRwdXQ6IHBhZ2dfdGFiXzIuYiwgKFBB UlRJQUwgYXZnKHBhZ2dfdGFiXzIuYSkpLA0KKFBBUlRJQUwgbWF4KHBhZ2dfdGFiXzIuYSkpLCAo UEFSVElBTCBjb3VudCgqKSksIChQQVJUSUFMDQpzdW0ocGFnZ190YWJfMi5hKSkNCkZpbHRlcjog KChQQVJUSUFMIHN1bShwYWdnX3RhYl8yLmEpKSA8IDcwMCkNClJlbGF0aW9uczogQWdncmVnYXRl IG9uIChwdWJsaWMuZnBhZ2dfdGFiX3AzDQpwYWdnX3RhYl8yKQ0KUmVtb3RlIFNRTDogU0VMRUNU IGIsIGF2Z19wX2ludDQoYSksIG1heChhKSwNCmNvdW50KCopLCBzdW0oYSkgRlJPTSBwdWJsaWMu cGFnZ190YWJfcDMgR1JPVVAgQlkgMQ0KDQoNCkluIGZvcmVpZ25fZ3JvdXBpbmdfb2soKQ0KNjU4 NiBpZiAoSXNBKGV4cHIsIEFnZ3JlZikpDQo2NTg3IHsNCjY1ODggaWYgKHBhcnRpYWwpDQo2NTg5 IHsNCjY1OTAgbWFya19wYXJ0aWFsX2FnZ3JlZigoQWdncmVmDQoqKSBleHByLCBBR0dTUExJVF9J TklUSUFMX1NFUklBTCk7DQo2NTkxIGNvbnRpbnVlOw0KNjU5MiB9DQo2NTkzIGVsc2UgaWYgKCFp c19mb3JlaWduX2V4cHIocm9vdCwNCmdyb3VwZWRfcmVsLCBleHByKSkNCjY1OTQgcmV0dXJuIGZh bHNlOw0KNjU5NQ0KNjU5NiB0bGlzdCA9IGFkZF90b19mbGF0X3RsaXN0KHRsaXN0LA0KbGlzdF9t YWtlMShleHByKSk7DQo2NTk3IH0NCg0KDQphdCBsZWFzdCB5b3Ugc2hvdWxkbid0IGRvIGFueXRo aW5nIHdpdGggZXhwciwgaWYgaXNfZm9yZWlnbl9leHByKCkNCnJldHVybmVkIGZhbHNlLiBJZiB3 ZSByZXN0cmljdCBwdXNoaW5nIGRvd24gcXVlcmllcyB3aXRoIGhhdmluZ1F1YWxzLA0KSSdtIG5v dCBxdWl0ZSBzdXJlIGhvdyBBZ2dyZWYgY2FuIGFwcGVhciBpbiBsb2NhbF9jb25kcy4NCg0KDQpB cyBmb3IgY2hhbmdlcyBpbiBwbGFubmVyLmMgKHNldEdyb3VwQ2xhdXNlUGFydGlhbCgpKSBJIGhh dmUgc2V2ZXJhbA0KcXVlc3Rpb25zLg0KDQoNCjEpIFdoeSBkb24ndCB3ZSBhZGQgbm9uX2dyb3Vw X2V4cHJzIHRvIHBhdGh0YXJnZXQtPmV4cHJzIHdoZW4NCnBhcnRpYWxfdGFyZ2V0LT5leHBycyBp cyBub3Qgc2V0Pw0KDQoNCjIpIFdlIHJlcGxhY2UgZXh0cmEtPnBhcnRpYWxfdGFyZ2V0LT5leHBy cyB3aXRoIHBhcnRpYWxfdGFyZ2V0LT5leHBycw0KYWZ0ZXIgcHJvY2Vzc2luZy4gV2h5IGFyZSB3 ZSBzdXJlIHRoYXQgYWZ0ZXIgdGhpcyB0bGVTb3J0R3JvdXBSZWYgaXMNCmNvcnJlY3Q/DQoNCg0K LS0NCkJlc3QgcmVnYXJkcywNCkFsZXhhbmRlciBQeWhhbG92LA0KUG9zdGdyZXMgUHJvZmVzc2lv bmFsDQoNCg0KDQo=