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 1oT16B-0004qD-K5 for pgsql-hackers@arkaria.postgresql.org; Tue, 30 Aug 2022 13:16:11 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oT16A-000397-BV for pgsql-hackers@arkaria.postgresql.org; Tue, 30 Aug 2022 13:16:10 +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 1oT16A-00038x-1O for pgsql-hackers@lists.postgresql.org; Tue, 30 Aug 2022 13:16:10 +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 1oT164-0001uu-RH for pgsql-hackers@lists.postgresql.org; Tue, 30 Aug 2022 13:16:08 +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=v0Se/PlDpzgiIywn5E4FhRUc/TkKiyaWhgefrcH/kZQ=; b=blwseDWX8JJHhSsXxXVeKsLlVO SAA8w3b6iKrU+lNi80erqqMz7UjIlkPYeKQBNdmH1aKe68t4nIW13YgSell6++4lHFVpnwBT5SP+9 yq+DcSP8HomedB964BO8V+IjcDDkS46D6seOOXbC0wIghMmTm0GE5wz5sdji+qrnmcFoVNO0n06jj OT3SSqgzlN+RyPQYu7lnGfMHhqT6zwSqDVsfwHbpxaxXvwmNKo/lnXTeYGyDFZQ3Abs2jsqK1cr7C IOvgXY0sngtj1KliLYQuZ3ZEADuiXMIkrH8eNA1VZbD+RllPeXrT9u/Aj6h8rJ2id1Y/Y87b+gtEb +T73MPWw==; 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 1oT15v-0000Fo-NA; Tue, 30 Aug 2022 13:15:58 +0000 Message-ID: <77b83b6d-bdb4-614d-4e7d-235ee72e2599@postgresql.org> Date: Tue, 30 Aug 2022 09:15:51 -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> From: "Jonathan S. Katz" In-Reply-To: Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="------------TY3MRCBCTEVCZJJtcwPielX4" 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) --------------TY3MRCBCTEVCZJJtcwPielX4 Content-Type: multipart/mixed; boundary="------------arNdb8lggB5MSUbWuoutq2Zz"; 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: <77b83b6d-bdb4-614d-4e7d-235ee72e2599@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> In-Reply-To: --------------arNdb8lggB5MSUbWuoutq2Zz Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: base64 T24gOC8xOC8yMiAzOjI5IEFNLCBUb21hcyBWb25kcmEgd3JvdGU6DQo+IA0KPiANCj4gT24g OC8xOC8yMiAwMzozMiwgRGF2aWQgUm93bGV5IHdyb3RlOg0KDQo+PiBIZXJlIGFyZSBhIGNv dXBsZSBvZiBwYXRjaGVzIHRvIGRlbW8gdGhlIGlkZWEuDQo+Pg0KPiANCj4gWWVhaCwgdGhh dCdzIGFuIG9wdGlvbiB0b28uIEkgc2hvdWxkIGhhdmUgbWVudGlvbmVkIGl0IGFsb25nIHdp dGggdGhlDQo+IGNwdV9vcGVyYXRvcl9jb3N0Lg0KPiANCj4gQlRXIHdvdWxkIHlvdSBtaW5k IHRha2luZyBhIGxvb2sgYXQgdGhlIGNvc3Rpbmc/IEkgdGhpbmsgaXQncyBmaW5lLCBidXQN Cj4gaXQgd291bGQgYmUgZ29vZCBpZiBzb21lb25lIG5vdCBpbnZvbHZlZCBpbiB0aGUgcGF0 Y2ggdGFrZXMgYSBsb29rLg0KDQpXaXRoIFJNVCBoYXQgb24sIGp1c3QgYSBmcmllbmRseSBy ZW1pbmRlciB0aGF0IHRoaXMgaXMgc3RpbGwgb24gdGhlIG9wZW4gDQppdGVtcyBsaXN0WzFd IC0tIHdlIGhhdmUgdGhlIEJldGEgNCByZWxlYXNlIG5leHQgd2VlayBhbmQgaXQgd291bGQg YmUgDQpncmVhdCBpZiB3ZSBjYW4gZ2V0IHRoaXMgcmVzb2x2ZWQgcHJpb3IgdG8gaXQuDQoN ClRoYW5rcyENCg0KSm9uYXRoYW4NCg0KWzFdIGh0dHBzOi8vd2lraS5wb3N0Z3Jlc3FsLm9y Zy93aWtpL1Bvc3RncmVTUUxfMTVfT3Blbl9JdGVtcw0KWzJdIA0KaHR0cHM6Ly93d3cucG9z dGdyZXNxbC5vcmcvbWVzc2FnZS1pZC85ZDI1MWFlYy1jZWEyLWJjMWEtNWVkOC00NmVmMGJj ZjZjNjlAcG9zdGdyZXNxbC5vcmcNCg== --------------arNdb8lggB5MSUbWuoutq2Zz-- --------------TY3MRCBCTEVCZJJtcwPielX4 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/x8QSccp8cZScFAmMODYcFAwAAAAAACgkQ8QSccp8cZSdQ Vw/+IfMT19NA7+ZcYiiM6FAIAcY5WXVlo/yOi3TTK4eJjFTHbWnQGvwsc95NMoIaOoSXKP2WDBVd Hj0ZXzp1ld71gJlTce94wBHqnWzCyMlsR07G9HQsUDVoowXHA/QCKtrrYO24F0c3SMsT887VsNDz Jirp9oi4mrh5lmGbzwZQWHUp8DVQ/7hOLOSvU8dXGgBo+ujOkAwP/w33DSViMDWAoVYWwHy45UfG sWgOAn3WnV3EC2NsdidNuToG+3iN/dJ4a7kGmXtdpSJNWmGzmDUU2HN2vN5y/JVR1m8eGpznTii+ 6R7e1U2HI6mLx2vx9zyOId8S3FqGPwzG1oKHu6VXX+y+sNGGyAs67sAFi5ZTol1D/NsO7hFn4QRT U3z7h/wp0632kS6E0GBxxVcnjJ8TtEGUSwpB2ZR9cIUvhBKnqHhvzAprU8lByOw61galW24yrj34 AW4svX4BS8WLTe8QVBYy98FqvChOx3/LUmI7qlyHEE/hQ6jpXMwo2oex2f2ZP/1bTVKUkV6dOImB Ij9F3l+Gg2k/0FWL5oVq1mziDYGzTR3RQT6z+JMVGs2xnkXOFb+McVa5eq6z9cMkmcFBiP9/wUux zNe8URX8XU35aFJtrab04TVrqftPhTMP8GjQ7kZTEJE4BdMdw6rzEQMEV/S/ywrXFxznjdPxQed1 9GE= =BSOK -----END PGP SIGNATURE----- --------------TY3MRCBCTEVCZJJtcwPielX4--