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 1oV0K8-0003vq-6D for pgsql-hackers@arkaria.postgresql.org; Mon, 05 Sep 2022 00:50:48 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oV0K6-000286-Ee for pgsql-hackers@arkaria.postgresql.org; Mon, 05 Sep 2022 00:50:46 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oV0K6-00027x-5I for pgsql-hackers@lists.postgresql.org; Mon, 05 Sep 2022 00:50:46 +0000 Received: from meldrar.postgresql.org ([2a02:c0:301:0:ffff::31]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oV0K3-0006vk-Qo for pgsql-hackers@lists.postgresql.org; Mon, 05 Sep 2022 00:50:45 +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=YXYAarBZyGIV7pmVJR1pWfevT3D9dyGpdzlbp3I1wfU=; b=u7y2S8wRGKOPhCI64kSdrg6Q9C ew5Chk0N8ZInmJjPgEv9bCkbEyg70wTGarPaV5roHZwOEyV3ofHEojj1skE9Pn76Do4oK2EyNtnjo /z23hB5dDPD7KITox5NqnmxIDp2/4ELuf9i8nR6GXOF+6FuGQcUBBHnvg5SLAsYVmcZtEYz8G1NWs 40xqrL95dV6fa1DmT5xZT5Nxsff/5z/a9MU6Y7gTbpg1ybdplmQ+EEGGbRPNb6/MxZ5TMIjnpg3tV mvRfuZMUHtCDL2YWPSK9UWR2X2eQWzjdWeWHg9u2JxpTp2Zkf4FJTs/gD3dMIIoqES3AEHI8fU2Yw 3HwAsS2w==; 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 1oV0Jw-0005QP-E5; Mon, 05 Sep 2022 00:50:38 +0000 Message-ID: Date: Sun, 4 Sep 2022 20:50:33 -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> <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> <9e564f8b-2c4b-6c6f-9334-e76e69af8f84@postgresql.org> <2d5d480b-d9e5-9d8f-dbca-ad6ec22a1b75@enterprisedb.com> From: "Jonathan S. Katz" In-Reply-To: <2d5d480b-d9e5-9d8f-dbca-ad6ec22a1b75@enterprisedb.com> Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="------------uzZFvV3b94lhzunaWaxhbNpE" 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) --------------uzZFvV3b94lhzunaWaxhbNpE Content-Type: multipart/mixed; boundary="------------UvQ3Pz0CFAPeTthO4z3QW0RA"; 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: Subject: Re: POC: GROUP BY optimization References: <721b3ff9-f214-f5d4-86c7-bae515bbec18@enterprisedb.com> <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> <9e564f8b-2c4b-6c6f-9334-e76e69af8f84@postgresql.org> <2d5d480b-d9e5-9d8f-dbca-ad6ec22a1b75@enterprisedb.com> In-Reply-To: <2d5d480b-d9e5-9d8f-dbca-ad6ec22a1b75@enterprisedb.com> --------------UvQ3Pz0CFAPeTthO4z3QW0RA Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: base64 T24gOS80LzIyIDY6MTQgUE0sIFRvbWFzIFZvbmRyYSB3cm90ZToNCg0KPiBJJ3ZlIHB1c2hl ZCB0aGUgZml4IHRvIDE1K21hc3Rlci4gSW4gdGhlIGVuZCBJIGp1c3QgdXNlZCBEYXZpZCdz IHBhdGNoZXMNCj4gdGhhdCBzZXQgcGFyYWxsZWxfc2V0dXBfY29zdCB0byAwLg0KDQpUaGFu a3MhIEkgaGF2ZSBjbG9zZWQgdGhlIG9wZW4gaXRlbS4NCg0KSm9uYXRoYW4NCg== --------------UvQ3Pz0CFAPeTthO4z3QW0RA-- --------------uzZFvV3b94lhzunaWaxhbNpE 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/x8QSccp8cZScFAmMVR9kFAwAAAAAACgkQ8QSccp8cZSe6 jg//SW2tD2RLEUuqDGNnfYS9RXeThNNsNiPtBhbSK5QBwamOV1w+jopvrNBCHZ7qcxtDx0feeqA0 A3rC58NUXMpkvGmCC5p8HrDnjakFeSr+J7uT1NcgVCbsdBwabKqxCHiQOoGK67ZaSzFiJ13t2By2 8P16r+Tr29ibvjt3w82lXjFRyqKWirCWxl1TsXORoHnuH6z0BILxiVGeMT9FvE9gQWk0VT1lMocQ gie20m2STyfkqvApE3cwvm8yJWih2LkiEJDR1fQIY5B/WO0pG+vGkgF2CQ1mSjTSVeW+s9bVNkqj Bd1cimO6TnC0xOOvCeRXYEveUyKjtj1Q0l/1hpaa0dGDOgpO1B578hg3FucpIzP5vyhSi5dEPF88 WF3A7j6qtjI7lQA7pRmLzknqEMPllILIXA4e6aiwuT99IyPZW2TC99zD6luuOzOU0K4RQnqOJ9Kr /BP5tPUwqWzE+oi3O6FnYvcZ39gLop4zIOfgrpaXEwstBmWgkIKjFMi6QhjMS+XGem2bioSXXbV6 JfojaJnDQHrULW235Ap5vB+th6s64myvHU29q/O3cxhHjt9ksfqE5On1foey29zgkz2T4ixy96a/ YmGI16jhi6/fcrx7WDl26ZgEWn05b+NNCUGIClvC5jIU25flURy2wn1AuHMxgYgErWWDKijmz6gV zbI= =VUux -----END PGP SIGNATURE----- --------------uzZFvV3b94lhzunaWaxhbNpE--