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.96) (envelope-from ) id 1whQr9-000Ddk-21 for pgsql-hackers@arkaria.postgresql.org; Wed, 08 Jul 2026 11:54:24 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1whQr8-0072o1-0L for pgsql-hackers@arkaria.postgresql.org; Wed, 08 Jul 2026 11:54:22 +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.96) (envelope-from ) id 1whQr7-0072nr-2L for pgsql-hackers@lists.postgresql.org; Wed, 08 Jul 2026 11:54:22 +0000 Received: from mail-japaneastazlp170100000.outbound.protection.outlook.com ([2a01:111:f403:c405::] helo=TY3P286CU002.outbound.protection.outlook.com) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1whQr5-000000009D7-40rl for pgsql-hackers@lists.postgresql.org; Wed, 08 Jul 2026 11:54:21 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector10001; d=microsoft.com; cv=none; b=rHWLq8wmawSutSN2KRnNTGOF//wZgkKtPFRb0afx3lg9MV7RFD75cAHVtR0Na7+/MEMeTATPEM6WJgxBL3aDPVpt4rCMqPSkcg+V3wwJtqUcod0zbLdIW8qoaK/1KYK5HmrS9KbJjwlHaqZYcNM8seRY6zqsFgY2qF8BZFK0Gi5Dp/zmEDS6HObuTaqE5mcJD2Igb8K1VZ6WLQTei/e0M0Y+YXdns8JCqRXZeXOFPBIu2ofqORHfXUQX+vvQ5ndtPKoJZrM7htaYg2AQ2gRr6dnkbK1MZEyxeXGWgI64a7UzycGw/lydYQmGnHjW1CpmQNjaQxiVxTL05js2TeLiQg== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector10001; 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=aSNnLD6T4noEkwkuJNMJ7uq2/6qXbQa+Hhst4w27oh4=; b=YhGxp8qdjhRaDR6O4qGBX1wh464ypRZ2iFg5AuSwoS1hgyrkrh2Tr+6UevToxnP2Sfo9QB6Ib9okQ9d2pzcLD2ulG0zr42EkXMjdrSO3QZlXzUwdzDhKhIb09U9Gt45WK/OdToy62/VYQtAGDwXDMifRZvadc6k2XQN7l1l4DXOJW+81Z/ud1FPLqtjKUNokDEe7Sffthlxl1R8wGDxssOhH/+cXfPwFr42cMGh5+f2Z8i6ZitYWrHKhy69xV8P2zkIFBdj8MWlQU9B9TkXPePdhaeRKKIZT4JUGxRcrbPBeKcfEU/cTZw3aqkm6JPBy64gfIg4rtEeWJmixM2Y03Q== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=ntt.com; dmarc=pass action=none header.from=ntt.com; dkim=pass header.d=ntt.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=ntt.com; s=selector2; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=aSNnLD6T4noEkwkuJNMJ7uq2/6qXbQa+Hhst4w27oh4=; b=0TpLstRfU6AuZNOmFOfYihOHK/jIf6UcUwm+/lNcCnnjyZSGmK0BdJSM6A7mI888fX5/K4ugPanWmReomgGbc4/BCI88tm54gzwnwR1E5uYe52GKHrUv2cDbQNtfUmjCNqJoa9Ydhf8iWmd/JJbR+TPfjrQt30ymMqjljIufXj0676oyhJrd4wIemvkfnbKp45dCgoMEAlhtjVw4DUQfZ0dFYbgNMeomakQfy5oTmGqgmseTgGJpX1bjq5NQu7MefdGXUzw5m0xvRHL+PhPmRtKxcQTSrbquDDmkH2LlSZUpN6YZoblkbViRnrlQMZmqgrrXDXlpkYS7J8Bbyp+oRg== Received: from TY4P301MB1299.JPNP301.PROD.OUTLOOK.COM (2603:1096:405:2f4::12) by OS9P301MB1837.JPNP301.PROD.OUTLOOK.COM (2603:1096:604:44a::13) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.21.181.15; Wed, 8 Jul 2026 11:54:13 +0000 Received: from TY4P301MB1299.JPNP301.PROD.OUTLOOK.COM ([fe80::b808:e442:a218:f6eb]) by TY4P301MB1299.JPNP301.PROD.OUTLOOK.COM ([fe80::b808:e442:a218:f6eb%5]) with mapi id 15.21.0181.010; Wed, 8 Jul 2026 11:54:13 +0000 From: Tatsuro Yamada To: Richard Guo CC: Tatsuro Yamada , David Rowley , Ashutosh Bapat , "pgsql-hackers@lists.postgresql.org" Subject: RE: Add enable_groupagg GUC parameter to control GroupAggregate usage Thread-Topic: Add enable_groupagg GUC parameter to control GroupAggregate usage Thread-Index: AQHb1rj0Bus22so71kKo5U5qUnYfBLP6qzuAgAKjUwCAAFv8AIAHerSAgAbLKgCCRL4LAIAAHwBwgAHuggCABPA9cIAMX0eAgAABrACAAdoPQA== Date: Wed, 8 Jul 2026 11:54:13 +0000 Message-ID: References: In-Reply-To: Accept-Language: ja-JP, en-US Content-Language: ja-JP X-MS-Has-Attach: X-MS-TNEF-Correlator: authentication-results: dkim=none (message not signed) header.d=none;dmarc=none action=none header.from=ntt.com; x-ms-publictraffictype: Email x-ms-traffictypediagnostic: TY4P301MB1299:EE_|OS9P301MB1837:EE_ x-ms-office365-filtering-correlation-id: 0c20eb09-a153-4cba-b8bc-08dedce7a13d x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0;ARA:13230040|366016|19092799006|23010399003|1800799024|376014|56012099006|11063799006|38070700021|18002099003|22082099003|4143699003; x-microsoft-antispam-message-info: oyemyrKz5s5DJJ+EA9HpqzxrkDcZKNTlrPPuYW7mQRROs2yn4/+nQzoicFi55MExTbeoUMZjRFs3WUPZM6+Dk1ChWBoFJ0TeEszoS3EDbAqg0UPD2l0pkMH4NfbS74r/yaZirQiPbdsNZjEXBcC1Y7ywwzmqTdoNtnhlMXZTLYCfkaRrpIiO34sWtzohOIdqzJ73T6zT5oyhK6JYPyl3/5BdxbuO07CqpWUqisYvlifSifOLqE8ekMhBAkKC1tm6uHP3BaJETXNRTXtuEPWeBXcOy75zco0hp1W8vrQXh9nVChONrPgkVAZONBy+CCu0sfHbnrXE8RqMt2jCjrLQgJcXN8TQ3Dt95QnMpOjAzHlAtFHF3FRAOjZ4kxHbCD3/BzHA2hrut5e2cUlYCCRAifho3v4+f3FBPz0Fk99fxKKojKgkkV45ipuBE0bQcI6j7+dL91id7ml5qeSELqpzG3m4G0YoDoFOsFO5QkbR9Nw76ynlrjNlU4ibIfdVTZsLNMdU9TGmHH0WbeZ+CAWtQAjUVWWiLE+LtsxvBV1vgDsDv/Bu6NHOKdBfqoNtWBXmY6c1qbDJqLvaLfxlg4txExmvSa+bx8yrRCah0ECt5KmvzkwyVouMrVyqtRrhddOd06edp3q1s7ePjisKrH3tUE2+MCFJSu+VNkaHFc7l48DQDCkMfXtatsymrX4hSmngB+dXVYYQj3X3Rri5h+U5qOgU1AyZbMO42vQc23x365U= x-forefront-antispam-report: CIP:255.255.255.255;CTRY:;LANG:ja;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:TY4P301MB1299.JPNP301.PROD.OUTLOOK.COM;PTR:;CAT:NONE;SFS:(13230040)(366016)(19092799006)(23010399003)(1800799024)(376014)(56012099006)(11063799006)(38070700021)(18002099003)(22082099003)(4143699003);DIR:OUT;SFP:1101; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?utf-8?B?Mk1ONzQ4eHJjMldiNk5RL1JEZTBQaW5kWEwyc0wvUHlqeWhqaVdYOVg1OHBU?= =?utf-8?B?QjNRWnNCZlhvbVA1cnFCVGQ4TEpvSjZqZTNrbWtrYzBwQ1VLTkwvTXd0ajNo?= =?utf-8?B?N3RocUEvYUthNk00MDJlNy9kcW1LZ3ZWOXp1MXhKTU4zZ1dVWU95ckpoWnN4?= =?utf-8?B?Q092THhCSC9KcElSMFVMbHNDblhMbFVzOVdHNExLbSttQWpOY29hdkFvZTFF?= =?utf-8?B?YkNwOU5aWURZeEhWOXpzMEJqNERPbmRqSVV2UFRHd1ZOYXRueUtja2tpRVQ4?= =?utf-8?B?Y1I5SDZVaU9kV2FRSmgxSzM5TEF1eWhjcnhvajB3aVRZWUFITWV3OGV6VHRR?= =?utf-8?B?VjYrN2FGUUwyWjhhWXJrR2JGd1IyNUpZczVsUXRIZktvby9UWU9mV0dGSDNU?= =?utf-8?B?UTkrMnYyOC9wNHNNdGdVQUdQdHhBUzkzbU9WL21QVVRDM3RXNVd2a1NsOGk0?= =?utf-8?B?dWJKbFRjUXJvQzBsbEJFcjI0aWovYVFNQ0tkK3dqQ1MyZStKTFhlSk1rd1Zy?= =?utf-8?B?WVNHM1BRMnhwd3BCMnBCMmRVQjJpZ1loWmtaWS9VNVhnMVJ4MVdBSzZaZnR3?= =?utf-8?B?bTNOa1dhVFVwR0ZxaG9YdkRzOG9TOHVCV3o4ZEpuNlV6L3NubXN1em1XSmM1?= =?utf-8?B?MUlLYmdKWkF3VHJOcy8rQUpmOGxuTEtTUzRlaGlLODB2RTZFbnRBWnpSM0tP?= =?utf-8?B?MUMvbGR5Vm1rU1FTRXN3WjUxSlB0bDBwa3BCY3NqKy8xUlVqbHd2S2l0Qm5B?= =?utf-8?B?NHpUc29vNjF0WVpNWXowNng3Z2xJVnUya1padXJBbThLeGxicXkyMzZJc1M1?= =?utf-8?B?cmRVQ0V0VHVpZmdEVk8yWGtKK29zL2tiU3p1YWhvOS9JdHV0VHhMWHB6QXg2?= =?utf-8?B?bU9ER2MzOEtReUliVVhGdGg3VHo2NGtJYXdyQ2R2b1lBVllSQW1ibm9BTCtX?= =?utf-8?B?L1Q1VjY2Yno0bVlMcFdBamlGbFczSE1ZeG52OVZldTQ0MnA5dmlBcDVtMGNI?= =?utf-8?B?ay81MHBnNy9ad2hwTjNwUEU2WkNwU0ZDVFE0SitPbFcxRjNWM1F1R0FNZDRR?= =?utf-8?B?Vk0yVm5YNnpsbng4cHhCeXQvSTVqYnJ2ZUxaQnUrTUc2YTBpY29FbWt5NkRk?= =?utf-8?B?eEFBRlZCS2R2SU9iRUxhRDYxOU5ZOHJFWHJTQTNnUFFBb2laU3Eza09uZ1Qw?= =?utf-8?B?Y3dMU0UrYVFKanlJcDFsOEIzMnFRQjYwM0FKbHJsUFNMczVtSWZFSFRiNjQ2?= =?utf-8?B?NW0zNHVRcjcyQ0tKcVBPL0dabGg4ZjIxKzF2eWxkOHZPd2t3Z0dYTXcxU1R6?= =?utf-8?B?RnNPQ3FqclZUV0xxV0VqbExoNEdpU05pMFIyZU5KcER3YTI0SGZySU9hYmI2?= =?utf-8?B?ZlN2YVRDT2k5UU8rODBpc1lVL3B0dUU1bjdsM2k4R1NQOHZNS0NEMEoydzRV?= =?utf-8?B?dzZPdG14RHVJNDdsYTR3anBMRUtYdzgrZTF6TkpQcGRHdFJsaCs2MTVVSklC?= =?utf-8?B?cXQ1dGU4RS9jdmZ0Y0JzVm8yME01Wmd4NUdReG1VOFJVQ0h0NHo1UWFlVmRn?= =?utf-8?B?YnNwd1BFNXYvNXJoSXo3RHFiU05uMm9oTG5pbG82VlJZeEhZMXMrYjlLaFNK?= =?utf-8?B?cXlyaXBvT3dlRjhWa2IzR3g1R1VVam9BamlWVWV0amUzb3FrVUwvUlhRZHVh?= =?utf-8?B?L1FHbmNZYXhkZUR4djFNVXd0U1UxSHRSOE41bUZuSTNNeG5RaUdoN2tic1Iy?= =?utf-8?B?dkdobGYyeHRlOGNQRkx6OVlTSnpGUkRNdkV1RTdmM3FrdS9BWXNkOFZINjdJ?= =?utf-8?B?dnVaa0FwdnZzMHJhUFk5d0J1S0hHU3lCVGphTjVzRjlrK3V0TG9CU3hOUWFL?= =?utf-8?B?YzJzTUwyOG1wLzkxRjFiSitCSUl1YUNOTkRlcDNsdFB1RjBwKzFTMk5Gcmgy?= =?utf-8?B?b0ZyQW4veUdMYm5CbmI5UEs2WE00ZTFNY29ueUUydk40N08yMno3RmxMMm53?= =?utf-8?B?Rm8yeFpBVlhQbUh6SUtHVFkwNjZOSkRKS0ZmL3dxdTZBM0NadXliTk0xZC9k?= =?utf-8?B?OG5MVHZ2cGoxVnNVYUY2L0FlVlAxMXp6MW1Mbmo3NndDVGxuQUR0T21ITG11?= =?utf-8?B?NmpMZXc4T2gwMElvT2NxOFVxdWhub3kyTjhOT01BV3FacFBHdUV5MzdaUSs4?= =?utf-8?B?U1QyRVN5VERmSXN2Y05RTFNSWjF6ZktLZXFJNEpzOTRwdUl0dmFVNnYwcGZp?= =?utf-8?B?bXcxUVN3VUxyemdFc0NxcDFNcG9lbk5NaGV3Z1ExMDh0UVQ5alFNRUp0dkM0?= =?utf-8?Q?g1WMRjEcgGxTON7yz9?= Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 MIME-Version: 1.0 X-OriginatorOrg: ntt.com X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: TY4P301MB1299.JPNP301.PROD.OUTLOOK.COM X-MS-Exchange-CrossTenant-Network-Message-Id: 0c20eb09-a153-4cba-b8bc-08dedce7a13d X-MS-Exchange-CrossTenant-originalarrivaltime: 08 Jul 2026 11:54:13.3673 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: a629ef32-67ba-47a6-8eb3-ec43935644fc X-MS-Exchange-CrossTenant-mailboxtype: HOSTED X-MS-Exchange-CrossTenant-userprincipalname: oiDue9Ol2ade6VliTPe03awpaTnEGJ9HExOMZmTLGX8NpBQubmz/wJ5bZ6Nmt5TLG3i+VsrB9z1EZ15AEDi7Cw== X-MS-Exchange-Transport-CrossTenantHeadersStamped: OS9P301MB1837 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk SGkgUmljaGFyZCwNCg0KPj4gQXR0YWNoZWQgaXMgYSByZWJhc2VkIHBhdGNoIHRvIG1ha2UgY2Zi b3Qgd29yayBhZ2Fpbi4NCj4NCj5JIGludGVuZCB0byBwdXNoIHRoaXMgcGF0Y2ggc29vbi4gIFRo YXQgd2F5IG5ld2x5IGFkZGVkIHRlc3QgY2FzZXMgY2FuDQo+c3RhcnQgdXNpbmcgZW5hYmxlX2dy b3VwYWdnIGRpcmVjdGx5LiAgT3RoZXJ3aXNlIHdlJ2xsIGhhdmUgdG8ga2VlcA0KPnJlYmFzaW5n IGl0IHRvIGNvbnZlcnQgYW55IG5ldyB0ZXN0cyB0aGF0IHVzZSBlbmFibGVfc29ydCB0byBmb3Jj ZQ0KPmhhc2hlZCBncm91cGluZy4gIEFueSB0aG91Z2h0cz8NCg0KSSdtIGluIGZhdm9yIG9mIGNv bW1pdHRpbmcgdGhpcy4NCkJlZm9yZSB5b3UgZG8sIEknZCBsaWtlIHRvIGNsYXJpZnkgb25lIHBv aW50IHJlZ2FyZGluZyB0aGUgY29tbWl0IG1lc3NhZ2UuIA0KV291bGQgaXQgbWFrZSBzZW5zZSB0 byBsaXN0IGJvdGggb2YgdXMgYXMgYXV0aG9ycz8NCg0KVGhlIHJlYXNvbiBJIGFzayBpcyB0aGF0 IHlvdSBtYWRlIHN1YnN0YW50aWFsIGNoYW5nZXMgdG8gdGhlIHBhdGNoLCANCmluY2x1ZGluZyBo YW5kbGluZyBhZGRpdGlvbmFsIHBsYW4gbm9kZXMgc3VjaCBhcyBTZXRPcCBhbmQgYWRkaW5nIHJl Z3Jlc3Npb24gDQp0ZXN0cy4gR2l2ZW4gdGhvc2UgY29udHJpYnV0aW9ucywgSSB3b25kZXJlZCB3 aGV0aGVyIGl0IHdvdWxkIGJlIG1vcmUgDQphcHByb3ByaWF0ZSBmb3IgYm90aCBvZiB1cyB0byBi ZSBsaXN0ZWQgYXMgYXV0aG9ycy4gKEkndmUgc2VlbiBwYXN0IGNvbW1pdHMgdGhhdCANCmluY2x1 ZGVkIHR3byBBdXRob3I6IGxpbmVzLikNCkknbSBoYXBweSB0byBsZWF2ZSB0aGF0IGRlY2lzaW9u IHRvIHlvdS4NCg0KQnkgdGhlIHdheSwgSSByZS1yYW4gdGhlIHRlc3QgcXVlcnkgZnJvbSB0aGUg aW5pdGlhbCBlbWFpbCBpbiB0aGlzIHRocmVhZC4NClRoZSBleGVjdXRpb24gdGltZXMgd2VyZToN Cg0KICBEZWZhdWx0OiAyNSw3OTEuNjQyIG1zDQogIFNFVCBlbmFibGVfZ3JvdXBhZ2cgVE8gb2Zm OzogMSwwMDYuODM5IG1zDQoNClRoaXMgYWdhaW4gY29uZmlybWVkIGFuIGFwcHJveGltYXRlbHkg MjV4IHNwZWVkdXAuDQoNCk9mIGNvdXJzZSwgdGhlIGFjdHVhbCBiZW5lZml0IGRlcGVuZHMgb24g dGhlIHNwZWNpZmljIHF1ZXJ5LCBidXQgSSBiZWxpZXZlIA0KdGhpcyBwYXJhbWV0ZXIgd2lsbCBh bGxvdyB1c2VycyB0byBpbXByb3ZlIHF1ZXJ5IHBlcmZvcm1hbmNlIGluIG1vcmUgc2l0dWF0aW9u cy4NCg0KUmVnYXJkcywNClRhdHN1cm8gWWFtYWRhDQoNCj4gLS0tLS1PcmlnaW5hbCBNZXNzYWdl LS0tLS0NCj4gRnJvbTogUmljaGFyZCBHdW8gPGd1b2ZlbmdsaW51eEBnbWFpbC5jb20+DQo+IFNl bnQ6IFR1ZXNkYXksIEp1bHkgNywgMjAyNiAzOjUzIFBNDQo+IFRvOiBUYXRzdXJvIFlhbWFkYe+8 iOWxseeUsOmBlOacl++8iSA8dGF0c3Vyby55YW1hZGFAbnR0LmNvbT4NCj4gQ2M6IFRhdHN1cm8g WWFtYWRhIDx5YW1hdGF0dHN1QGdtYWlsLmNvbT47IERhdmlkIFJvd2xleQ0KPiA8ZGdyb3dsZXlt bEBnbWFpbC5jb20+OyBBc2h1dG9zaCBCYXBhdA0KPiA8YXNodXRvc2guYmFwYXQub3NzQGdtYWls LmNvbT47IHBnc3FsLWhhY2tlcnNAbGlzdHMucG9zdGdyZXNxbC5vcmcNCj4gU3ViamVjdDogUmU6 IEFkZCBlbmFibGVfZ3JvdXBhZ2cgR1VDIHBhcmFtZXRlciB0byBjb250cm9sIEdyb3VwQWdncmVn YXRlDQo+IHVzYWdlDQo+IA0KPiBPbiBUdWUsIEp1bCA3LCAyMDI2IGF0IDM6NDfigK9QTSBSaWNo YXJkIEd1byA8Z3VvZmVuZ2xpbnV4QGdtYWlsLmNvbT4NCj4gd3JvdGU6DQo+ID4gQXR0YWNoZWQg aXMgYSByZWJhc2VkIHBhdGNoIHRvIG1ha2UgY2Zib3Qgd29yayBhZ2Fpbi4NCj4gDQo+IEkgaW50 ZW5kIHRvIHB1c2ggdGhpcyBwYXRjaCBzb29uLiAgVGhhdCB3YXkgbmV3bHkgYWRkZWQgdGVzdCBj YXNlcyBjYW4NCj4gc3RhcnQgdXNpbmcgZW5hYmxlX2dyb3VwYWdnIGRpcmVjdGx5LiAgT3RoZXJ3 aXNlIHdlJ2xsIGhhdmUgdG8ga2VlcA0KPiByZWJhc2luZyBpdCB0byBjb252ZXJ0IGFueSBuZXcg dGVzdHMgdGhhdCB1c2UgZW5hYmxlX3NvcnQgdG8gZm9yY2UNCj4gaGFzaGVkIGdyb3VwaW5nLiAg QW55IHRob3VnaHRzPw0KPiANCj4gLSBSaWNoYXJkDQo=