Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oTkpb-0003Ug-Fv for pgsql-hackers@arkaria.postgresql.org; Thu, 01 Sep 2022 14:06:08 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oTkpZ-0002ha-Pb for pgsql-hackers@arkaria.postgresql.org; Thu, 01 Sep 2022 14:06:05 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oTkpZ-0002hK-Fl for pgsql-hackers@lists.postgresql.org; Thu, 01 Sep 2022 14:06:05 +0000 Received: from meldrar.postgresql.org ([2a02:c0:301:0:ffff::31]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oTkpS-0008TJ-Gz for pgsql-hackers@lists.postgresql.org; Thu, 01 Sep 2022 14:06:05 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Content-Type:In-Reply-To:From:References:Cc: To:Subject:MIME-Version:Date:Message-ID:Sender:Reply-To: Content-Transfer-Encoding:Content-ID:Content-Description; bh=yshE133Vvl0s3SR6xftfbm6PKb2hVqgG2jgIT9Z2Iog=; b=Ou3TzG0o23/678vHV9SERWwNCJ JwV6zSWI+TRWzHBaDEWXj6a4jk74RtpRxJ4Lef5bmlgNr4kCjeYmqETBMtiJce4XOo6spfYYKCPMh qNOtkEn36d29EC3p/Jofw08Qwxvlb8/HwUP2BABddrs+SLR+8LczikZOY+8wT1WY1aG2JMveGAMqO RHpactwrPh08RBCzsCLtMooDycUHet+ya9WYAKgs8FUF4tVrUO/9fBdnAMgCjq90OebbrQTcfQR0f 2WxtoeS/gX3VR4gG+5zQkGEjvFF0nMWI8bv/xSEj1tdi80n9EAvr74BYEoGRvCyVC9X7Z9QOY6GAT x+jKQZ0Q==; Received: from [52.119.84.106] (helo=[192.168.88.177]) by meldrar.postgresql.org with esmtpsa (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1oTkpL-0005Pz-IZ; Thu, 01 Sep 2022 14:05:53 +0000 Message-ID: <9e564f8b-2c4b-6c6f-9334-e76e69af8f84@postgresql.org> Date: Thu, 1 Sep 2022 10:05:48 -0400 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:91.0) Gecko/20100101 Thunderbird/91.13.0 Subject: Re: POC: GROUP BY optimization Content-Language: en-US To: Tomas Vondra , David Rowley Cc: Michael Paquier , Zhihong Yu , "Andrey V. Lepikhov" , Teodor Sigaev , Tomas Vondra , PostgreSQL Developers References: <721b3ff9-f214-f5d4-86c7-bae515bbec18@enterprisedb.com> <7bea462e-8c3e-0f8c-c7d5-f4daa12f3baf@postgrespro.ru> <9af89543-3d17-4c98-59de-1daa5bceeb06@enterprisedb.com> <9408e450-60c6-6fbc-d5c4-467bb0abfe67@postgrespro.ru> <44472925-f6c6-e8de-6f72-0451458532c4@enterprisedb.com> <7a80a207-5e8e-b80c-476c-2d290b0526e9@enterprisedb.com> <65941e87-86c1-c09c-8ad5-8e102aebe8ee@enterprisedb.com> <683635b8-381b-5b08-6069-d6a45de19a12@enterprisedb.com> <77b83b6d-bdb4-614d-4e7d-235ee72e2599@postgresql.org> <217ab546-4c78-9364-9282-a6dcefa066ea@enterprisedb.com> From: "Jonathan S. Katz" In-Reply-To: <217ab546-4c78-9364-9282-a6dcefa066ea@enterprisedb.com> Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="------------azmGlZkXMkQG4y5zAHh3U9cq" X-Host-Lookup-Failed: Reverse DNS lookup failed for 52.119.84.106 (failed) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is an OpenPGP/MIME signed message (RFC 4880 and 3156) --------------azmGlZkXMkQG4y5zAHh3U9cq Content-Type: multipart/mixed; boundary="------------BDpRn6RMh6YyBmhOREjJavb2"; protected-headers="v1" From: "Jonathan S. Katz" To: Tomas Vondra , David Rowley Cc: Michael Paquier , Zhihong Yu , "Andrey V. Lepikhov" , Teodor Sigaev , Tomas Vondra , PostgreSQL Developers Message-ID: <9e564f8b-2c4b-6c6f-9334-e76e69af8f84@postgresql.org> Subject: Re: POC: GROUP BY optimization References: <721b3ff9-f214-f5d4-86c7-bae515bbec18@enterprisedb.com> <7bea462e-8c3e-0f8c-c7d5-f4daa12f3baf@postgrespro.ru> <9af89543-3d17-4c98-59de-1daa5bceeb06@enterprisedb.com> <9408e450-60c6-6fbc-d5c4-467bb0abfe67@postgrespro.ru> <44472925-f6c6-e8de-6f72-0451458532c4@enterprisedb.com> <7a80a207-5e8e-b80c-476c-2d290b0526e9@enterprisedb.com> <65941e87-86c1-c09c-8ad5-8e102aebe8ee@enterprisedb.com> <683635b8-381b-5b08-6069-d6a45de19a12@enterprisedb.com> <77b83b6d-bdb4-614d-4e7d-235ee72e2599@postgresql.org> <217ab546-4c78-9364-9282-a6dcefa066ea@enterprisedb.com> In-Reply-To: <217ab546-4c78-9364-9282-a6dcefa066ea@enterprisedb.com> --------------BDpRn6RMh6YyBmhOREjJavb2 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: base64 T24gOS8xLzIyIDk6MDYgQU0sIFRvbWFzIFZvbmRyYSB3cm90ZToNCj4gDQo+IA0KPiBPbiA4 LzMwLzIyIDE1OjE1LCBKb25hdGhhbiBTLiBLYXR6IHdyb3RlOg0KPj4gT24gOC8xOC8yMiAz OjI5IEFNLCBUb21hcyBWb25kcmEgd3JvdGU6DQo+Pj4NCj4+Pg0KPj4+IE9uIDgvMTgvMjIg MDM6MzIsIERhdmlkIFJvd2xleSB3cm90ZToNCj4+DQo+Pj4+IEhlcmUgYXJlIGEgY291cGxl IG9mIHBhdGNoZXMgdG8gZGVtbyB0aGUgaWRlYS4NCj4+Pj4NCj4+Pg0KPj4+IFllYWgsIHRo YXQncyBhbiBvcHRpb24gdG9vLiBJIHNob3VsZCBoYXZlIG1lbnRpb25lZCBpdCBhbG9uZyB3 aXRoIHRoZQ0KPj4+IGNwdV9vcGVyYXRvcl9jb3N0Lg0KPj4+DQo+Pj4gQlRXIHdvdWxkIHlv dSBtaW5kIHRha2luZyBhIGxvb2sgYXQgdGhlIGNvc3Rpbmc/IEkgdGhpbmsgaXQncyBmaW5l LCBidXQNCj4+PiBpdCB3b3VsZCBiZSBnb29kIGlmIHNvbWVvbmUgbm90IGludm9sdmVkIGlu IHRoZSBwYXRjaCB0YWtlcyBhIGxvb2suDQo+Pg0KPj4gV2l0aCBSTVQgaGF0IG9uLCBqdXN0 IGEgZnJpZW5kbHkgcmVtaW5kZXIgdGhhdCB0aGlzIGlzIHN0aWxsIG9uIHRoZSBvcGVuDQo+ PiBpdGVtcyBsaXN0WzFdIC0tIHdlIGhhdmUgdGhlIEJldGEgNCByZWxlYXNlIG5leHQgd2Vl ayBhbmQgaXQgd291bGQgYmUNCj4+IGdyZWF0IGlmIHdlIGNhbiBnZXQgdGhpcyByZXNvbHZl ZCBwcmlvciB0byBpdC4NCj4+DQo+IA0KPiBJIGtub3cuIEknbGwgZml4IHRoaXMgYnkgdHdl YWtpbmcgb25lIG9mIHRoZSBjb3N0IGd1Y3MsIG1lbnRpb25lZCBieSBEYXZpZC4NCg0KR3Jl YXQgLS0gdGhhbmtzIGZvciB0aGUgdXBkYXRlIQ0KDQpKb25hdGhhbg0K --------------BDpRn6RMh6YyBmhOREjJavb2-- --------------azmGlZkXMkQG4y5zAHh3U9cq Content-Type: application/pgp-signature; name="OpenPGP_signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="OpenPGP_signature" -----BEGIN PGP SIGNATURE----- wsF5BAABCAAjFiEE+oS2la8r95ogZD/x8QSccp8cZScFAmMQvDwFAwAAAAAACgkQ8QSccp8cZScm fxAAq2Og16+RKIGSRn/6AR5qXSK3AqN368q4mTFZ80YMy8ynDD0IARwhUjP5u48mG3rc9PBAAxzV BTvf+tLNXjPGbk3KLDTdmwToYgI4Aauib/PZsiL8pwsRER5et6kGTaIdj+FXuWikWAItL4Mp9g9b irZ0pMGHp1juvPmKT0PUsjfIbEsOr71AmoTu5Ju2zz41P3iqX3hXTZbfZWOFvMIjlhn48jvKdghI 2gMBP4UZPnf/6KnU1CwKDgxL1F6AQ/yoYWO1JspBZQujONeXczYAsd4MG6Zazh9IatN3yekpNaGm aBBQuavrEsSOyJuhRbJusLbMxKnA6rNhF//1V9yl7b1B5bpSNkxDc32fhfprFcrczdC+AHS1w5Dg ZiT+t5aq1ME/hNX26u8cZGr09C7FFwaDUQk9K2IlsGIu6iqKvBxSuZ381bamWG1iZOmTI2hf8mIw /ke+6Z3w4HY+LC+/R6QZSstxwwxMv1CYKjVXIxSsj2289jo2wcXJhT0Z/PZInRLL8XaouOOM750D 1+JbXehjA5Kj0wYdI4/MRNaJr5FRORPvOpwq6nFS25+ZSxFEeGQ/i0lAcEaQqNRWWC+AUQbjitjx cmV/TFilHYPE85gx6V1NU2Lbbl/oidzMZNSoCDaM0zqjE+wk8YdaEvNOxtOmDsEF+q7y91QeHbyU 5wk= =Cirj -----END PGP SIGNATURE----- --------------azmGlZkXMkQG4y5zAHh3U9cq--