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 1v6PBb-0043iT-PV for pgsql-committers@arkaria.postgresql.org; Wed, 08 Oct 2025 08:06:11 +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 1v6PBZ-008Udb-FV for pgsql-committers@arkaria.postgresql.org; Wed, 08 Oct 2025 08:06:10 +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 1v6PBZ-008UdT-3y for pgsql-committers@lists.postgresql.org; Wed, 08 Oct 2025 08:06:10 +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.96) (envelope-from ) id 1v6PBX-000dQa-0A for pgsql-committers@lists.postgresql.org; Wed, 08 Oct 2025 08:06:09 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Date:Message-Id:Subject:To:From:MIME-Version: Content-Type:Sender:Reply-To:Cc:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=ablWa1SAkDAhv2TpaOQWWsplGmglT+PugqhD39RwHjo=; b=d96+WgS+nUHrkjPIhKGxsaBeHJ kH/iuE9p9K2U6pKGI7eLYXQ8VENbxV1eVxnefMY2Qq4P3cdtFIN2CTy2s6TzwQIytzY6vRxSq5z3V +en/LEUdUk1ZqrgulApdk/rsaZIUabiiuloLcalby6fmoNOZpNTWaYYieuhMBNIXha+i0Vs+YwsrQ 9vBBHVil1399CVar0waIab9LPbjBnWBAxsIkWEhDz8nVJobG2blvvf0bEom6BnucNh4caTakQ0oK3 njlYUqcOR/EFrraoh8kzLC7sqj4XoSdfCxuumYBGKMlwjvVKjZ3hYqQnb3pemMWhJHGtMYjruw84V G+yO6jog==; Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1v6PBX-001nUs-IN for pgsql-committers@lists.postgresql.org; Wed, 08 Oct 2025 08:06:07 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1v6PBW-000dzo-2a for pgsql-committers@lists.postgresql.org; Wed, 08 Oct 2025 08:06:06 +0000 Content-Type: multipart/mixed; boundary="===============5292864729860371729==" MIME-Version: 1.0 From: Richard Guo To: pgsql-committers@lists.postgresql.org Subject: pgsql: Implement Eager Aggregation X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Wed, 08 Oct 2025 08:06:06 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============5292864729860371729== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 SW1wbGVtZW50IEVhZ2VyIEFnZ3JlZ2F0aW9uCgpFYWdlciBhZ2dyZWdhdGlvbiBpcyBhIHF1ZXJ5 IG9wdGltaXphdGlvbiB0ZWNobmlxdWUgdGhhdCBwYXJ0aWFsbHkKcHVzaGVzIGFnZ3JlZ2F0aW9u IHBhc3QgYSBqb2luLCBhbmQgZmluYWxpemVzIGl0IG9uY2UgYWxsIHRoZQpyZWxhdGlvbnMgYXJl IGpvaW5lZC4gIEVhZ2VyIGFnZ3JlZ2F0aW9uIG1heSByZWR1Y2UgdGhlIG51bWJlciBvZgppbnB1 dCByb3dzIHRvIHRoZSBqb2luIGFuZCB0aHVzIGNvdWxkIHJlc3VsdCBpbiBhIGJldHRlciBvdmVy YWxsIHBsYW4uCgpJbiB0aGUgY3VycmVudCBwbGFubmVyIGFyY2hpdGVjdHVyZSwgdGhlIHNlcGFy YXRpb24gYmV0d2VlbiB0aGUKc2Nhbi9qb2luIHBsYW5uaW5nIHBoYXNlIGFuZCB0aGUgcG9zdC1z Y2FuL2pvaW4gcGhhc2UgbWVhbnMgdGhhdAphZ2dyZWdhdGlvbiBzdGVwcyBhcmUgbm90IHZpc2li bGUgd2hlbiBjb25zdHJ1Y3RpbmcgdGhlIGpvaW4gdHJlZSwKbGltaXRpbmcgdGhlIHBsYW5uZXIn cyBhYmlsaXR5IHRvIGV4cGxvaXQgYWdncmVnYXRpb24tYXdhcmUKb3B0aW1pemF0aW9ucy4gIFRv IGltcGxlbWVudCBlYWdlciBhZ2dyZWdhdGlvbiwgd2UgY29sbGVjdCBpbmZvcm1hdGlvbgphYm91 dCBhZ2dyZWdhdGUgZnVuY3Rpb25zIGluIHRoZSB0YXJnZXRsaXN0IGFuZCBIQVZJTkcgY2xhdXNl LCBhbG9uZwp3aXRoIGdyb3VwaW5nIGV4cHJlc3Npb25zIGZyb20gdGhlIEdST1VQIEJZIGNsYXVz ZSwgYW5kIHN0b3JlIGl0IGluCnRoZSBQbGFubmVySW5mbyBub2RlLiAgRHVyaW5nIHRoZSBzY2Fu L2pvaW4gcGxhbm5pbmcgcGhhc2UsIHRoaXMKaW5mb3JtYXRpb24gaXMgdXNlZCB0byBldmFsdWF0 ZSBlYWNoIGJhc2Ugb3Igam9pbiByZWxhdGlvbiB0bwpkZXRlcm1pbmUgd2hldGhlciBlYWdlciBh Z2dyZWdhdGlvbiBjYW4gYmUgYXBwbGllZC4gIElmIGFwcGxpY2FibGUsIHdlCmNyZWF0ZSBhIHNl cGFyYXRlIFJlbE9wdEluZm8sIHJlZmVycmVkIHRvIGFzIGEgZ3JvdXBlZCByZWxhdGlvbiwgdG8K cmVwcmVzZW50IHRoZSBwYXJ0aWFsbHktYWdncmVnYXRlZCB2ZXJzaW9uIG9mIHRoZSByZWxhdGlv biBhbmQKZ2VuZXJhdGUgZ3JvdXBlZCBwYXRocyBmb3IgaXQuCgpHcm91cGVkIHJlbGF0aW9uIHBh dGhzIGNhbiBiZSBnZW5lcmF0ZWQgaW4gdHdvIHdheXMuICBUaGUgZmlyc3QgbWV0aG9kCmludm9s dmVzIGFkZGluZyBzb3J0ZWQgYW5kIGhhc2hlZCBwYXJ0aWFsIGFnZ3JlZ2F0aW9uIHBhdGhzIG9u IHRvcCBvZgp0aGUgbm9uLWdyb3VwZWQgcGF0aHMuICBUbyBsaW1pdCBwbGFubmluZyB0aW1lLCB3 ZSBvbmx5IGNvbnNpZGVyIHRoZQpjaGVhcGVzdCBvciBzdWl0YWJseS1zb3J0ZWQgbm9uLWdyb3Vw ZWQgcGF0aHMgaW4gdGhpcyBzdGVwLgpBbHRlcm5hdGl2ZWx5LCBncm91cGVkIHBhdGhzIGNhbiBi ZSBnZW5lcmF0ZWQgYnkgam9pbmluZyBhIGdyb3VwZWQKcmVsYXRpb24gd2l0aCBhIG5vbi1ncm91 cGVkIHJlbGF0aW9uLiAgSm9pbmluZyB0d28gZ3JvdXBlZCByZWxhdGlvbnMKaXMgY3VycmVudGx5 IG5vdCBzdXBwb3J0ZWQuCgpUbyBmdXJ0aGVyIGxpbWl0IHBsYW5uaW5nIHRpbWUsIHdlIGN1cnJl bnRseSBhZG9wdCBhIHN0cmF0ZWd5IHdoZXJlCnBhcnRpYWwgYWdncmVnYXRpb24gaXMgcHVzaGVk IG9ubHkgdG8gdGhlIGxvd2VzdCBmZWFzaWJsZSBsZXZlbCBpbiB0aGUKam9pbiB0cmVlIHdoZXJl IGl0IHByb3ZpZGVzIGEgc2lnbmlmaWNhbnQgcmVkdWN0aW9uIGluIHJvdyBjb3VudC4KVGhpcyBz dHJhdGVneSBhbHNvIGhlbHBzIGVuc3VyZSB0aGF0IGFsbCBncm91cGVkIHBhdGhzIGZvciB0aGUg c2FtZQpncm91cGVkIHJlbGF0aW9uIHByb2R1Y2UgdGhlIHNhbWUgc2V0IG9mIHJvd3MsIHdoaWNo IGlzIGltcG9ydGFudCB0bwpzdXBwb3J0IGEgZnVuZGFtZW50YWwgYXNzdW1wdGlvbiBvZiB0aGUg cGxhbm5lci4KCkZvciB0aGUgcGFydGlhbCBhZ2dyZWdhdGlvbiB0aGF0IGlzIHB1c2hlZCBkb3du IHRvIGEgbm9uLWFnZ3JlZ2F0ZWQKcmVsYXRpb24sIHdlIG5lZWQgdG8gY29uc2lkZXIgYWxsIGV4 cHJlc3Npb25zIGZyb20gdGhpcyByZWxhdGlvbiB0aGF0CmFyZSBpbnZvbHZlZCBpbiB1cHBlciBq b2luIGNsYXVzZXMgYW5kIGluY2x1ZGUgdGhlbSBpbiB0aGUgZ3JvdXBpbmcKa2V5cywgdXNpbmcg Y29tcGF0aWJsZSBvcGVyYXRvcnMuICBUaGlzIGlzIGVzc2VudGlhbCB0byBlbnN1cmUgdGhhdCBh bgphZ2dyZWdhdGVkIHJvdyBmcm9tIHRoZSBwYXJ0aWFsIGFnZ3JlZ2F0aW9uIG1hdGNoZXMgdGhl IG90aGVyIHNpZGUgb2YKdGhlIGpvaW4gaWYgYW5kIG9ubHkgaWYgZWFjaCByb3cgaW4gdGhlIHBh cnRpYWwgZ3JvdXAgZG9lcy4gIFRoaXMKZW5zdXJlcyB0aGF0IGFsbCByb3dzIHdpdGhpbiB0aGUg c2FtZSBwYXJ0aWFsIGdyb3VwIHNoYXJlIHRoZSBzYW1lCiJkZXN0aW55Iiwgd2hpY2ggaXMgY3J1 Y2lhbCBmb3IgbWFpbnRhaW5pbmcgY29ycmVjdG5lc3MuCgpPbmUgcmVzdHJpY3Rpb24gaXMgdGhh dCB3ZSBjYW5ub3QgcHVzaCBwYXJ0aWFsIGFnZ3JlZ2F0aW9uIGRvd24gdG8gYQpyZWxhdGlvbiB0 aGF0IGlzIGluIHRoZSBudWxsYWJsZSBzaWRlIG9mIGFuIG91dGVyIGpvaW4sIGJlY2F1c2UgdGhl Ck5VTEwtZXh0ZW5kZWQgcm93cyBwcm9kdWNlZCBieSB0aGUgb3V0ZXIgam9pbiB3b3VsZCBub3Qg YmUgYXZhaWxhYmxlCndoZW4gd2UgcGVyZm9ybSB0aGUgcGFydGlhbCBhZ2dyZWdhdGlvbiwgd2hp bGUgd2l0aCBhCm5vbi1lYWdlci1hZ2dyZWdhdGlvbiBwbGFuIHRoZXNlIHJvd3MgYXJlIGF2YWls YWJsZSBmb3IgdGhlIHRvcC1sZXZlbAphZ2dyZWdhdGlvbi4gIFB1c2hpbmcgcGFydGlhbCBhZ2dy ZWdhdGlvbiBpbiB0aGlzIGNhc2UgbWF5IHJlc3VsdCBpbgp0aGUgcm93cyBiZWluZyBncm91cGVk IGRpZmZlcmVudGx5IHRoYW4gZXhwZWN0ZWQsIG9yIHByb2R1Y2UgaW5jb3JyZWN0CnZhbHVlcyBm cm9tIHRoZSBhZ2dyZWdhdGUgZnVuY3Rpb25zLgoKSWYgd2UgaGF2ZSBnZW5lcmF0ZWQgYSBncm91 cGVkIHJlbGF0aW9uIGZvciB0aGUgdG9wbW9zdCBqb2luIHJlbGF0aW9uLAp3ZSBmaW5hbGl6ZSBp dHMgcGF0aHMgYXQgdGhlIGVuZC4gIFRoZSBmaW5hbCBwYXRocyB3aWxsIGNvbXBldGUgaW4gdGhl CnVzdWFsIHdheSB3aXRoIHBhdGhzIGJ1aWx0IGZyb20gcmVndWxhciBwbGFubmluZy4KClRoZSBw YXRjaCB3YXMgb3JpZ2luYWxseSBwcm9wb3NlZCBieSBBbnRvbmluIEhvdXNrYSBpbiAyMDE3LiAg VGhpcwpjb21taXQgcmV3b3JrcyB2YXJpb3VzIGltcG9ydGFudCBhc3BlY3RzIGFuZCByZXdyaXRl cyBtb3N0IG9mIHRoZQpjdXJyZW50IGNvZGUuICBIb3dldmVyLCB0aGUgb3JpZ2luYWwgcGF0Y2gg YW5kIHJldmlld3Mgd2VyZSB2ZXJ5CnVzZWZ1bC4KCkF1dGhvcjogUmljaGFyZCBHdW8gPGd1b2Zl bmdsaW51eEBnbWFpbC5jb20+CkF1dGhvcjogQW50b25pbiBIb3Vza2EgPGFoQGN5YmVydGVjLmF0 PiAoaW4gYW4gb2xkZXIgdmVyc2lvbikKUmV2aWV3ZWQtYnk6IFJvYmVydCBIYWFzIDxyb2JlcnRt aGFhc0BnbWFpbC5jb20+ClJldmlld2VkLWJ5OiBKaWFuIEhlIDxqaWFuLnVuaXZlcnNhbGl0eUBn bWFpbC5jb20+ClJldmlld2VkLWJ5OiBUZW5kZXIgV2FuZyA8dG5kcndhbmdAZ21haWwuY29tPgpS ZXZpZXdlZC1ieTogTWF0aGV1cyBBbGNhbnRhcmEgPG1hdGhldXNzc2lsdjk3QGdtYWlsLmNvbT4K UmV2aWV3ZWQtYnk6IFRvbSBMYW5lIDx0Z2xAc3NzLnBnaC5wYS51cz4KUmV2aWV3ZWQtYnk6IERh dmlkIFJvd2xleSA8ZGdyb3dsZXltbEBnbWFpbC5jb20+ClJldmlld2VkLWJ5OiBUb21hcyBWb25k cmEgPHRvbWFzQHZvbmRyYS5tZT4gKGluIGFuIG9sZGVyIHZlcnNpb24pClJldmlld2VkLWJ5OiBB bmR5IEZhbiA8emhpaHVpZmFuMTIxM0AxNjMuY29tPiAoaW4gYW4gb2xkZXIgdmVyc2lvbikKUmV2 aWV3ZWQtYnk6IEFzaHV0b3NoIEJhcGF0IDxhc2h1dG9zaC5iYXBhdC5vc3NAZ21haWwuY29tPiAo aW4gYW4gb2xkZXIgdmVyc2lvbikKRGlzY3Vzc2lvbjogaHR0cHM6Ly9wb3N0Z3IuZXMvbS9DQU1i V3M0OGp6THJQdDFKXzAwWmNQWlhXVVFLYXdRT0ZFOFJPYy1BRGlZcXNxcnBCTndAbWFpbC5nbWFp bC5jb20KCkJyYW5jaAotLS0tLS0KbWFzdGVyCgpEZXRhaWxzCi0tLS0tLS0KaHR0cHM6Ly9naXQu cG9zdGdyZXNxbC5vcmcvcGcvY29tbWl0ZGlmZi84ZTExODU5MTAyZjk0N2U2MTQ1YWNkZDgwOWU1 Y2RjZGZiZTkwZmE1CgpNb2RpZmllZCBGaWxlcwotLS0tLS0tLS0tLS0tLQpjb250cmliL3Bvc3Rn cmVzX2Zkdy9leHBlY3RlZC9wb3N0Z3Jlc19mZHcub3V0ICAgIHwgICA0OSArLQpkb2Mvc3JjL3Nn bWwvY29uZmlnLnNnbWwgICAgICAgICAgICAgICAgICAgICAgICAgIHwgICAzMSArCnNyYy9iYWNr ZW5kL29wdGltaXplci9SRUFETUUgICAgICAgICAgICAgICAgICAgICAgfCAgMTEwICsrCnNyYy9i YWNrZW5kL29wdGltaXplci9nZXFvL2dlcW9fZXZhbC5jICAgICAgICAgICAgfCAgIDIxICstCnNy Yy9iYWNrZW5kL29wdGltaXplci9wYXRoL2FsbHBhdGhzLmMgICAgICAgICAgICAgfCAgNDY3ICsr KysrLQpzcmMvYmFja2VuZC9vcHRpbWl6ZXIvcGF0aC9qb2lucmVscy5jICAgICAgICAgICAgIHwg IDE5MyArKysKc3JjL2JhY2tlbmQvb3B0aW1pemVyL3BsYW4vaW5pdHNwbGFuLmMgICAgICAgICAg ICB8ICAzNzAgKysrKysKc3JjL2JhY2tlbmQvb3B0aW1pemVyL3BsYW4vcGxhbm1haW4uYyAgICAg ICAgICAgICB8ICAgIDkgKwpzcmMvYmFja2VuZC9vcHRpbWl6ZXIvcGxhbi9wbGFubmVyLmMgICAg ICAgICAgICAgIHwgIDEyNCArLQpzcmMvYmFja2VuZC9vcHRpbWl6ZXIvdXRpbC9hcHBlbmRpbmZv LmMgICAgICAgICAgIHwgICA1MSArCnNyYy9iYWNrZW5kL29wdGltaXplci91dGlsL3JlbG5vZGUu YyAgICAgICAgICAgICAgfCAgNjUwICsrKysrKysrCnNyYy9iYWNrZW5kL3V0aWxzL21pc2MvZ3Vj X3BhcmFtZXRlcnMuZGF0ICAgICAgICAgfCAgIDE2ICsKc3JjL2JhY2tlbmQvdXRpbHMvbWlzYy9w b3N0Z3Jlc3FsLmNvbmYuc2FtcGxlICAgICB8ICAgIDIgKwpzcmMvaW5jbHVkZS9ub2Rlcy9wYXRo bm9kZXMuaCAgICAgICAgICAgICAgICAgICAgIHwgIDExNyArKwpzcmMvaW5jbHVkZS9vcHRpbWl6 ZXIvcGF0aG5vZGUuaCAgICAgICAgICAgICAgICAgIHwgICAgNCArCnNyYy9pbmNsdWRlL29wdGlt aXplci9wYXRocy5oICAgICAgICAgICAgICAgICAgICAgfCAgICA0ICsKc3JjL2luY2x1ZGUvb3B0 aW1pemVyL3BsYW5tYWluLmggICAgICAgICAgICAgICAgICB8ICAgIDEgKwpzcmMvdGVzdC9yZWdy ZXNzL2V4cGVjdGVkL2NvbGxhdGUuaWN1LnV0Zjgub3V0ICAgIHwgICAzMiArLQpzcmMvdGVzdC9y ZWdyZXNzL2V4cGVjdGVkL2VhZ2VyX2FnZ3JlZ2F0ZS5vdXQgICAgIHwgMTcxNCArKysrKysrKysr KysrKysrKysrKysKc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9qb2luLm91dCAgICAgICAgICAg ICAgICB8ICAgMTIgKy0Kc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9wYXJ0aXRpb25fYWdncmVn YXRlLm91dCB8ICAgIDIgKwpzcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL3N5c3ZpZXdzLm91dCAg ICAgICAgICAgIHwgICAgMyArLQpzcmMvdGVzdC9yZWdyZXNzL3BhcmFsbGVsX3NjaGVkdWxlICAg ICAgICAgICAgICAgIHwgICAgMiArLQpzcmMvdGVzdC9yZWdyZXNzL3NxbC9lYWdlcl9hZ2dyZWdh dGUuc3FsICAgICAgICAgIHwgIDM4MCArKysrKwpzcmMvdGVzdC9yZWdyZXNzL3NxbC9wYXJ0aXRp b25fYWdncmVnYXRlLnNxbCAgICAgIHwgICAgMiArCnNyYy90b29scy9wZ2luZGVudC90eXBlZGVm cy5saXN0ICAgICAgICAgICAgICAgICAgfCAgICAzICsKMjYgZmlsZXMgY2hhbmdlZCwgNDI5MyBp bnNlcnRpb25zKCspLCA3NiBkZWxldGlvbnMoLSkKCg== --===============5292864729860371729==--