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 1qLZdN-0009ww-Vr for pgsql-hackers@arkaria.postgresql.org; Tue, 18 Jul 2023 01:36:14 +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 1qLZdM-001xDh-CW for pgsql-hackers@arkaria.postgresql.org; Tue, 18 Jul 2023 01:36:12 +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 1qLZdL-001xDY-1K for pgsql-hackers@lists.postgresql.org; Tue, 18 Jul 2023 01:36:12 +0000 Received: from mx05.melco.co.jp ([192.218.140.145]) by makus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qLZdD-0002EC-70 for pgsql-hackers@postgresql.org; Tue, 18 Jul 2023 01:36:07 +0000 Received: from mr05.melco.co.jp (mr05 [133.141.98.165]) by mx05.melco.co.jp (Postfix) with ESMTP id 4R4hNx0msyzMrQHh; Tue, 18 Jul 2023 10:36:01 +0900 (JST) Received: from mr05.melco.co.jp (unknown [127.0.0.1]) by mr05.imss (Postfix) with ESMTP id 4R4hNx05CJzMwB8h; Tue, 18 Jul 2023 10:36:01 +0900 (JST) Received: from mf03_second.melco.co.jp (unknown [192.168.20.183]) by mr05.melco.co.jp (Postfix) with ESMTP id 4R4hNx03VVzMw3Yf; Tue, 18 Jul 2023 10:36:01 +0900 (JST) Received: from mf03.melco.co.jp (unknown [133.141.98.183]) by mf03_second.melco.co.jp (Postfix) with ESMTP id 4R4hNx01cGz5fl1; Tue, 18 Jul 2023 10:36:01 +0900 (JST) Received: from JPN01-OS0-obe.outbound.protection.outlook.com (unknown [104.47.23.106]) by mf03.melco.co.jp (Postfix) with ESMTP id 4R4hNw6n3NzMstpS; Tue, 18 Jul 2023 10:36:00 +0900 (JST) ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=ISUsb8rg1VJJKVDLZ1rNCPY4+uA7Z1EYIA8liUW1s9n7HH+mBAunoCClV2TvtOM1u3YsIdw2Tx0tSvTYm+eAg0FYaetsa1SZq1uPf7MuzuCTWbgMBDa/oj4uoDUbDjYdfVBiZgJt1VdnyCHZBEO0ATAVwNv9I9dIYNhGO3HcMHMKydF5YhqbcF7w3ti4ShDtrJVumuRCj6hTp40z5QBN2rY/anQoL6N7fdEECuJNqq0wEPjVtljZPluNwpEeyoM68JAB+7Sj+IWsP/1I2KOcTfAJHg0S4EKARPsBPH3E9koi3NC6Srot4a31IOPlxphRA686xZFVzjzF5vffjgBI5A== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector9901; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1; bh=WUDZzSj6Rb4vqKibo//uCVIpW9T1/Y1ZjNBeW9r8DEo=; b=F3liHoB4z0fhwu7RewlNtbAB5Rr72zFxHRwGjIvx/03HuUTxs+bY1xHQNy4Lf5omk79xSN6CFjeJk4onDMFpEfrLmeXUBkpmTMnjqmBonuRQ+XZAR5NN4f14ibgO0h3RkC7pKq2jlAGgW2GDNCNWUkw1QHe0H+qEGURFGjS5RFk/tdthTzvMbgrVokEtWsmBLkkD9ki02U/Al1F9e0pMSvuE4KXVIfl/ZToHMMqh1a9lRGZoLUfhakn1PhLDAUi7PLHoGWifRd4G0d9jctH7L/2oEX069du4HeJ9+5AkoyMJ+zo0+RqOeOmMPAB1ghMxmtCX0oUO+3iI1QI4ufgV6A== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=df.mitsubishielectric.co.jp; dmarc=pass action=none header.from=df.mitsubishielectric.co.jp; dkim=pass header.d=df.mitsubishielectric.co.jp; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=mitsubishielectricgroup.onmicrosoft.com; s=selector2-mitsubishielectricgroup-onmicrosoft-com; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=WUDZzSj6Rb4vqKibo//uCVIpW9T1/Y1ZjNBeW9r8DEo=; b=ixXg5IW90AURja0ha/BuCJiSAhok6aZWJZIyHf9mxYIVGZrE488TO8fNrId1niYdH3viUrJOSdTClIxZgu5D9wyl+KbgOgvSrTphll9bPDXaVkc8BwdRMGXJjUi8knT4rh3g5JwEzzBlQ63qtgOW9OcpgWmKKBqJQKwykQWoRjk= Received: from OS3PR01MB6660.jpnprd01.prod.outlook.com (2603:1096:604:10e::8) by TYWPR01MB11048.jpnprd01.prod.outlook.com (2603:1096:400:391::6) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.6588.33; Tue, 18 Jul 2023 01:35:58 +0000 Received: from OS3PR01MB6660.jpnprd01.prod.outlook.com ([fe80::96fd:a9f9:8a75:3086]) by OS3PR01MB6660.jpnprd01.prod.outlook.com ([fe80::96fd:a9f9:8a75:3086%7]) with mapi id 15.20.6588.031; Tue, 18 Jul 2023 01:35:54 +0000 From: "Fujii.Yuki@df.MitsubishiElectric.co.jp" To: Alexander Pyhalov CC: Bruce Momjian , PostgreSQL-development , Andres Freund , Tom Lane , Tomas Vondra , Julien Rouhaud , Daniel Gustafsson , Ilya Gladyshev , "Fujii.Yuki@df.MitsubishiElectric.co.jp" Subject: RE: Partial aggregates pushdown Thread-Topic: Partial aggregates pushdown Thread-Index: AQHYPYasTfJpCf0a4028YJm7JfY5bazLVbIAgAA/QgCAzsLGAICupJqAgAOhGYCAC47OQIAAf6sAgAAdMNCAAEyGgIAAtjrAgAD/KACABTrjIIAEWzOAgAyCOHCApWPpgIAAT1AggArXpoCAAFPI0IABO+iAgAMFFICABR/vAIAACpQAgABDk4CAAU/RgIBJ2XYAgAgC/oCAAC5WgIAGnISAgAQxEbCAAFHVgIAA0HSAgArptoCAAGksgIACJPSAgADj/XCAAGn4AIAcBMuAgAawUACABWxaMA== Date: Tue, 18 Jul 2023 01:35:53 +0000 Deferred-Delivery: Tue, 18 Jul 2023 01:35:51 +0000 Message-ID: References: <8ffedecae0d21a3cd93805baf1dcc0de@postgrespro.ru> <6893fbdcd63140179f4987b76edba95d@postgrespro.ru> In-Reply-To: <6893fbdcd63140179f4987b76edba95d@postgrespro.ru> Accept-Language: ja-JP, en-US Content-Language: ja-JP X-MS-Has-Attach: X-MS-TNEF-Correlator: x-melpop: 1 authentication-results: dkim=none (message not signed) header.d=none;dmarc=none action=none header.from=df.MitsubishiElectric.co.jp; x-ms-publictraffictype: Email x-ms-traffictypediagnostic: OS3PR01MB6660:EE_|TYWPR01MB11048:EE_ x-ms-office365-filtering-correlation-id: bed22e2f-9574-4cf0-bb74-08db872f543d x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0; x-microsoft-antispam-message-info: ce55YiRF1H/wR1LMaKnd3VK/YQIk8sF5s9DkkZ9dK7Eu0PqjJETslObJ13OfugSZvb/nQxAA8un/ccStwmn7jEVkDoZ1LLghFhe7u7XVYdRsOix/bXhQrX+KQ/jsTOgvNWueVirA2X1RmUfKV715rSRhv+SeiOxO3Yu30qlI7iNVhPxK2iYrYvxMDkn/jPm6fcxOZQ6XosL2Tx9uj0tWkMC6nxWkbi533VY+R02NyX9dKHV6K9ERoaox8al4iCNYiWKrMqVdWcIfTV0q6VXOX/CPZBid2F4/PBk4emKcJbT6onzYCBnTC6kACQ4bcj1uxGHz7P/mk3LfNL6oFREQH4NzmDd3wrSa1oV4c3q4kMQOqqP0pNBhkDfVbC5nosgMsOY4zldHbIRszz4GpVTDIyzFDqKQvUaRayazmyekLHtwgDWc2gXm9kDK2Qx6zc5q6mFO2QylMbx0Dd0vqFcApaRY3jtkTEq6nLmM/fnbaweDTHtO+hwbHcoz4Qx7VVuPD7ro5NPelys62zqfwmd1AqG7pMrlpbqGTOTAGJCNbTh6z+Obi4n34k7kvXhQ8thbaqJO0gr13Vl6LRznbLd5JwtOsmvTJdGIYS8TJImFCgrhiegjxKxxIfmTa80cfzPg x-forefront-antispam-report: CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:OS3PR01MB6660.jpnprd01.prod.outlook.com;PTR:;CAT:NONE;SFS:(13230028)(4636009)(366004)(39860400002)(396003)(346002)(136003)(376002)(451199021)(66476007)(66556008)(66446008)(64756008)(5660300002)(52536014)(6916009)(316002)(4326008)(76116006)(66946007)(8676002)(7116003)(41300700001)(8936002)(38070700005)(2906002)(55016003)(54906003)(33656002)(478600001)(7696005)(107886003)(71200400001)(9686003)(186003)(86362001)(26005)(6506007)(38100700002)(122000001)(3480700007);DIR:OUT;SFP:1102; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?utf-8?B?UkpSd2l3c3RGL2E1RWtnOHVsMDBoRWdKNmZ0U1hBNmNvekhka3RUYTJxdHli?= =?utf-8?B?YmxNWDFuRXNyU2owUTdZNWxYZkxCakdaYU5aQVU5UlJIdHJaVWNwNERsVEQv?= =?utf-8?B?a0wrM1p2YUhvQ1M0ci9CT2gwNWdEbWhoSkgzQXdNVXBkU0JWTEJRNFFTdHEx?= =?utf-8?B?RU9BeW52eGlyZUwrWnN3SE9jL2lhMXhabmVmNTJwRkR6Q2ZRZTRtM3paR01p?= =?utf-8?B?YzBaaVViYnJXa2ZSeW9tN3QydmZQUjVGYVY2aDBCNkREYUJVem93My93K1lF?= =?utf-8?B?RkRGYWtOazcvWnRubk1EUTQ5Y3J3bStxYVVqd3ZnUUZOUjlBNGhLYW5KVlo3?= =?utf-8?B?UkRzQSt5ZGtKSXF3SExFMHUzcVhwZ01XSCtXZ1IrRUlnRUlPWFRMb3lFVWJz?= =?utf-8?B?R3JPcmNYT1piM3ZuYk1tRWpSSUxsa1Y4eTY4LzBpZStXUjhsdkg3MVlYNTlp?= =?utf-8?B?aGFCc1pLZkd3Q0QvMHhzL0dTVm9GejZaZThnaGZvVGpTYlJvWXg3cFlhakV2?= =?utf-8?B?TmV3bjhBcTlWcEdselZGdWl1V1VtY2ZwWVBKbENpcHg3ZlI4Q05VUHJGUU9P?= =?utf-8?B?RTFvWTZncVJ3d1ZzcEIrNnVaRmVGVTVUS05kakVhS2crd01ibnRTaThxTVNO?= =?utf-8?B?WlRhaVlBd1RDd2hUWGkvNnMzR3dEQStoM0dBSFk2cENIcFZOSjNRK1BrNzVG?= =?utf-8?B?Y3lUbzFBaEdDZEorbThqODhPajRDU2ZZRWZBc2tjbjcvTi9qS0tPcXpNUU9n?= =?utf-8?B?WVNxMnBOc2xjRFh5cElBMGxRTzlnU09pczNnZjlyVW1mc3ZaQ2Ird21EZDlJ?= =?utf-8?B?OHNIeXNQZDZsMXovNXRhNE94VHZGVzREVGlkR0RWWE1GeUNMOENRTXdlWGIr?= =?utf-8?B?c3NZcEIwb0dPV2ZSMmFtcGdGRXFvZGp5U1RVK2k1U2EzWkpVeWZOZUgrNGhI?= =?utf-8?B?aVhSR1F0MVEzR2F3V3I2cHB2MXNEUUNsbWxIbm1yT3Z1cmRjcGoyUEY4ekI1?= =?utf-8?B?TDBPbUtSWkxxdVV3K3BseFowREQ4MHZpYisrY3JzRlFyVjJOcCtUNFRQdFFV?= =?utf-8?B?dThQVjNJdW9tVlNHY3VzOEh2cHc5RmczK1VuZmM4cFY2T0dxQ0Y3Rm1KaTlm?= =?utf-8?B?VUlRZ0xxV1htRFRLd2RjWk9SNlp3dzJyeVYvYTB0MmNER1didldNOURBZlZH?= =?utf-8?B?K0NodTEvTTdyem5mSU5SR3ZaQUt2WHJraFplckZTcWxCdWhobkJ3QUZ6dnpi?= =?utf-8?B?dVdab29OUHdlNmhYVnZ2R2JHc3VBZDJoV3NnUFpJTHAvdXNsVjdQNWFVVk8z?= =?utf-8?B?NnhNaUd2Ym54eVdJYnZwRzhyNEtFYVlwSjhlemlYMTJZQnl1dEs0YXZ5YnVS?= =?utf-8?B?UCtnSm5KcTZPaWU4L2hXREdGWGx6YVNaVlVNRy9IUU14SmJLb1dNalZvVUI5?= =?utf-8?B?SExveEFJVk1zaytxMSt1dTRTa09PZHIxUWRXdmQxbnlDVVV1WWpOOURJeFl4?= =?utf-8?B?cXJYQXNCZVF4YjhUL0JaU0dFaWlPK3NrUEMrTlhZRlVZWlZRZGxVSnVGcm1G?= =?utf-8?B?MVMxSlY2SnZpLzg4YUtrN243eTkzSmNqQ1VhMGlOZzdobmRsU3VaS1o2UUdp?= =?utf-8?B?RkxPU2I3N3dVS2hjcUhwQnZjUThsM0RGQWpQUzIvS1JKdWl5RjJVOW1XTlR0?= =?utf-8?B?Q3BHL2hvcEgwRU5IcnBUQ1FQbUIrMExUUklRM3FKejF4SVowcDNaU00xd256?= =?utf-8?B?Q1k5VEhUcEV5Zk1uczBoWk16Zm5QN2U3N2hrMDU5QVhrTmZiZDB5RmpraUQw?= =?utf-8?B?WFZDVmthV1duVi95bUNnQ0dDaVBtamZrTWxvMG90dm5qUG55Y0ZwY09JcDBE?= =?utf-8?B?d1RScHFHcmdwUlFDZ1pTUzJVa1VJbnN3NDBhcC9UdlJEMWJWNUhRRXErUS9Z?= =?utf-8?B?Z1hXbVJqQkNDUklqNklYc1Q4VEttS2pud1pUdEV2ZkxpUE1OOFZHOWF6V1Ns?= =?utf-8?B?b1AyZ3hnclRxTWtkdEwxN0hCdTF1NTlBV1cyNFVFODUwclYvZGpzYXhPSFZk?= =?utf-8?B?V0RwVmFaUmsvR0s5WEN0dHlycnczc0VYVWNZTEdjYjE2dFdKTHo2b2JZRFVR?= =?utf-8?Q?SsLetmxFGqG+iP+tFhbfQot4V?= Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 MIME-Version: 1.0 X-OriginatorOrg: df.MitsubishiElectric.co.jp X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: OS3PR01MB6660.jpnprd01.prod.outlook.com X-MS-Exchange-CrossTenant-Network-Message-Id: bed22e2f-9574-4cf0-bb74-08db872f543d X-MS-Exchange-CrossTenant-originalarrivaltime: 18 Jul 2023 01:35:54.9466 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: c5a75b62-4bff-4c96-a720-6621ce9978e5 X-MS-Exchange-CrossTenant-mailboxtype: HOSTED X-MS-Exchange-CrossTenant-userprincipalname: QfQVe3g1dkMuHZigYbVzesBi988b48MhDWxpjxEUW8PuSquV3tgtKWs1DdFke+ugue0l0QOkJKWzbj6JBsBVoQ== X-MS-Exchange-Transport-CrossTenantHeadersStamped: TYWPR01MB11048 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk SGkgTXIuUHloYWxvdi4NCg0KPiBGcm9tOiBBbGV4YW5kZXIgUHloYWxvdiA8YS5weWhhbG92QHBv c3RncmVzcHJvLnJ1Pg0KPiBTZW50OiBGcmlkYXksIEp1bHkgMTQsIDIwMjMgMTA6NDAgUE0NCj4g MSkgSW4gZm9yZWlnbl9qb2luX29rKCkgc2hvdWxkIHdlIHNldCBmcGluZm8tPnVzZXIgaWYNCj4g ZnBpbmZvLT5jaGVja19wYXJ0aWFsX2FnZ3JlZ2F0ZV9zdXBwb3J0IGlzIHNldCBsaWtlIGl0J3Mg ZG9uZSBmb3IgDQo+IGZwaW5mby0+dXNlX3JlbW90ZV9lc3RpbWF0ZT8gSXQgc2VlbXMgd2UgY2Fu IGVuZCB1cCB3aXRoIGZwaW5mby0+dXNlciANCj4gZnBpbmZvLT49DQo+IE5VTEwgaWYgdXNlX3Jl bW90ZV9lc3RpbWF0ZSBpcyBub3Qgc2V0Lg0KWW91IGFyZSByaWdodC4gSSB3aWxsIG1vZGlmeSB0 aGlzIHBhdGNoIGFjY29yZGluZyB0byB5b3VyIGFkdmljZS4NClRoYW5rIHlvdSBmb3IgYWR2aWNl Lg0KDQo+IDIpIEl0IHNlZWVtcyB3ZSBmb3VuZCBhbiBhZGRpdGlvbmFsIGlzc3VlIHdpdGggb3Jp Z2luYWwgcGF0Y2gsIHdoaWNoIA0KPiBpcyBwcmVzZW50IGluIGN1cnJlbnQgb25lLiBJJ20gYXR0 YWNoaW5nIGEgcGF0Y2ggd2hpY2ggc2VlbXMgdG8gZml4IA0KPiBpdCwgYnV0IEknbSBub3QgcXVp dGUgc3VyZSBpbiBpdC4NClRoYW5rIHlvdSBmb3IgcG9pbnRpbmcgb3V0IHRoZSBpc3N1ZS4NCklm IGEgcXVlcnkncyBncm91cC1ieSBjbGF1c2UgY29udGFpbnMgdmFyaWFibGUgYmFzZWQgZXhwcmVz c2lvbihub3QgdmFyaWFibGUpDQphbmQgdGhlIHF1ZXJ5J3Mgc2VsZWN0IGNsYXVzZSBjb250YWlu cyBhbm90aGVyIGV4cHJlc3Npb24sDQp0aGUgcGFydGlhbCBhZ2dyZWdhdGUgY291bGQgYmUgdW5z YWZlIHRvIHB1c2ggZG93bi4NCg0KQW4gZXhhbXBsZSBvZiBzdWNoIHF1ZXJpZXM6DQpTRUxFQ1Qg KGIvMik6Om51bWVyaWMsIGF2ZyhhKSwgbWF4KGEpLCBjb3VudCgqKSBGUk9NIHBhZ2dfdGFiIEdS T1VQIEJZIGIvMg0KDQpZb3VyIHBhdGNoIGRpc2FibGVzIHBhcnRpYWwgYWdncmVnYXRlIHB1c2hk b3duIGZvciBzdWNoIHF1ZXJpZXMuDQpJJ2xsIHNlZSBpZiB3ZSBjYW4gbW9kaWZ5IHRoZSBwYXRj aCB0byBzYWZlbHkgZG8gYSBwYXJ0aWFsIGFnZ3JlZ2F0ZSBwdXNoZG93biBmb3Igc3VjaCBxdWVy aWVzIGFzIHdlbGwuDQpTdWNoIGEgcXVlcnkgZXhwZWN0cyB0aGUgdmFyaWFibGUgaW4gdGhlIHNl bGVjdCBjbGF1c2UgZXhwcmVzc2lvbiB0byBiZSBpbmNsdWRlZCBpbiB0aGUgdGFyZ2V0IG9mIHRo ZSBncm91cGVkIHJlbA0KKGxldCBzZWUgbWFrZV9wYXJ0aWFsX2dyb3VwaW5nX3RhcmdldCksIA0K YnV0IHRoZSBvcmlnaW5hbCBncm91cGJ5IGNsYXVzZSBoYXMgbm8gcmVmZXJlbmNlIHRvIHRoaXMg dmFyaWFibGUsDQp0aGlzIHNlZW1zIHRvIGJlIHRoZSBkaXJlY3QgY2F1c2UobGV0IHNlZSBmb3Jl aWduX2dyb3VwaW5nX29rKS4gDQpJIHdpbGwgZXhhbWluZSB3aGV0aGVyIGEgc2FmZSBwdXNoZG93 biBjYW4gYmUgYWNoaWV2ZWQgYnkgbWF0Y2hpbmcgdGhlDQpncm91cGJ5IGNsYXVzZSBpbmZvcm1h dGlvbiByZWZlcmVuY2VkIGJ5IGZvcmVpZ25fZ3JvdXBpbmdfb2sgd2l0aCB0aGUgZ3JvdXBlZCBy ZWwgdGFyZ2V0IGluZm9ybWF0aW9uLg0KDQpTaW5jZXJlbHkgeW91cnMsDQpZdXVraSBGdWppaQ0K DQotLQ0KWXV1a2kgRnVqaWkNCkluZm9ybWF0aW9uIFRlY2hub2xvZ3kgUiZEIENlbnRlciBNaXRz dWJpc2hpIEVsZWN0cmljIENvcnBvcmF0aW9uDQo=