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 <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1v33KN-00AXgv-Nx
	for pgsql-hackers@arkaria.postgresql.org; Mon, 29 Sep 2025 02:09:23 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1v33KK-00GJbx-Qs
	for pgsql-hackers@arkaria.postgresql.org; Mon, 29 Sep 2025 02:09:21 +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 <guofenglinux@gmail.com>)
	id 1v33KK-00GJbQ-GN
	for pgsql-hackers@lists.postgresql.org; Mon, 29 Sep 2025 02:09:21 +0000
Received: from mail-yx1-xb135.google.com ([2607:f8b0:4864:20::b135])
	by makus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256
	(Exim 4.96)
	(envelope-from <guofenglinux@gmail.com>)
	id 1v33KI-000QiR-1w
	for pgsql-hackers@lists.postgresql.org;
	Mon, 29 Sep 2025 02:09:20 +0000
Received: by mail-yx1-xb135.google.com with SMTP id
 956f58d0204a3-635349b6fe6so2290750d50.2
        for <pgsql-hackers@lists.postgresql.org>;
 Sun, 28 Sep 2025 19:09:19 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20230601; t=1759111758; x=1759716558;
 darn=lists.postgresql.org;
        h=content-transfer-encoding:cc:to:subject:message-id:date:from
         :in-reply-to:references:mime-version:from:to:cc:subject:date
         :message-id:reply-to;
        bh=5XrKMtltp/A7EIdslbBpzU0I9Ig4P2BP0Utp1eXymzU=;
        b=SdzYtkNGFuo/uQtPIm0TkmI7oYFDsE390/uArsEsbLP078mtO5FORv2+sH0fCvMlgA
         xjDw3km/KmNT83Rcy1UGLahIXO4uJD+Rc3jQyzVm8Fs57x6emrlkz8dm1YwckAb9IN1S
         RIvGEv2+zYJIGJWSJlK1NgL96AbMOrA6e8B7W2gPH5ZIpN0Z8rb36V3y3kEPDpwewze1
         uyEUm077Ho1DRTx3G1UKP3L2ZQPEypmW1nBA6ufrSDAipULj6n2wXNMQSvxZMcI+PCaG
         texShIsGa9VbnSeeHzikLpg8zZnbU9bEM1rmplIAyB140STplNwkWsLEpMUcsRwSLWEV
         yLIw==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20230601; t=1759111758; x=1759716558;
        h=content-transfer-encoding:cc:to:subject:message-id:date:from
         :in-reply-to:references:mime-version:x-gm-message-state:from:to:cc
         :subject:date:message-id:reply-to;
        bh=5XrKMtltp/A7EIdslbBpzU0I9Ig4P2BP0Utp1eXymzU=;
        b=I9xeLNR4mYHW3CZfKua7EZ2Hf2dHM96qdauL7haoIKdipkXTU6ta8a2QNdlZSX0aI6
         eIbXBFrGVp59kfvb+1Rgw0qYwskc8I1yzAoXCNPaiLBlW5sr+3HmkgaLvskXV72gdtUS
         SoYvQ7LstIR2UJWYyz9m+f4LdOr0NnHq8+tVvEd2ESrDeEL8S4EdZsrSdHutVtTr6DY7
         Lz40yXFW5n9CO0ZLxUpiWttoEfY5vX1By6laF5zzLhH/uzcXzmG1Yd/cFJkZrNKcu1ml
         wFUNda0eKHm//66CySxvQLVQaLl6FJdx9fHE8vUGUVKjxsIdAJuhzxgLY+mzPwACmchY
         IURQ==
X-Forwarded-Encrypted: i=1;
 AJvYcCWBH31Q+WKc6MFhrdxrjJt3bH9qeFSbd9++TKVSzXB/HvVq4hD74Pw+f0uMlg2bYhBD/3es88yWJXqHmihZ@lists.postgresql.org
X-Gm-Message-State: AOJu0Yy6g6dT4IMYL215iAWWWvP7Cxp5Oj0Wra/5BgdglYIOQEzarE8P
	pnrry6LIbE/ulcseKwgreexUKHyhRsE4LH1oIA3x/0lGDr341PohJLSnDs7JSbtVTTARSoWTucH
	xzAY1ngIApW9r1Nhtv/Q7c0njZHXY4UY=
X-Gm-Gg: ASbGncvvznfiQ/euHGl9D78YhEA1MpA3tzUurFvtoQJfGVTMgXI7E3AyuqazBs5yK/l
	CYGZdwfXo/6EvoU+HPfImUvmADK4q7ShOpWKB+MXZiNcv/qAEp05EAedj4am0d7USJoMyGjws/M
	wVgKjjACICcSmmy57WGF9GwdDjDWvO07ZUUj1mpg8HlCryP80kTKGg4KdMgliq85Vrb4vAw+tt6
	Ka2HtZNoVI2WavqH45m
X-Google-Smtp-Source: 
 AGHT+IFe5EB6gAo98iZFf7MeKximB5cVewnuhtEpI993Sb40CekVIw6PBRTxxZeZF7VBgaHh743GGRgvEssrIB0cMvI=
X-Received: by 2002:a05:690e:244d:b0:635:4ecf:bdc6 with SMTP id
 956f58d0204a3-6361a89069emr10601091d50.40.1759111758513; Sun, 28 Sep 2025
 19:09:18 -0700 (PDT)
MIME-Version: 1.0
References: 
 <CAMbWs48jzLrPt1J_00ZcPZXWUQKawQOFE8ROc-ADiYqsqrpBNw@mail.gmail.com>
 <87il22cj51.fsf@163.com>
 <CAMbWs49=eAd2W9jCtGhaZPPp+SOC_2rg16RTG74xAht=hkr5JQ@mail.gmail.com>
 <CAMbWs49Nc4M3H+eCf1+8w8piDyEECjRb-gK_JMF4VvcyWwGEVQ@mail.gmail.com>
 <CAMbWs49E_dR0nobsExsyetpnBpHObLTsQLsEbWKQLkh0omPxNg@mail.gmail.com>
 <CAMbWs49B_qUiHvu2EqLHZRpLr3p_+QPBs50n2=L5ibYzniwTzA@mail.gmail.com>
 <CAMbWs48KCQtDymnYi4M=Vz+WMzo3fkBxffJsyk6VX6hOXXv+VA@mail.gmail.com>
 <CAMbWs49sv_MuOYqqrtmBN_oYf8VSQ2BXDwXaTpJTn_YfwyYdWQ@mail.gmail.com>
 <CAMbWs49U8Sddx_fGszPdvA3jp_nheynxaqm5Y4NqMV21VBYAuQ@mail.gmail.com>
 <CAMbWs4-LwyOg9ga+NVF7yQbMi0ZsZdN1G_sO2v=YJHV18=19+A@mail.gmail.com>
 <CALA8mJquG_zCJXfVwash5LKqHGtZXQmq7RfTSaRDUzGYeW=7Rw@mail.gmail.com>
 <CAMbWs4_EjgcBib5+y1LYcGB3EK3Y6R+OOxGKfJo42fDovadk1g@mail.gmail.com>
 <CALA8mJqe0anNM8_V6cOeOQnCHUTQggn7iOQNyQr1VaN_xMjz+w@mail.gmail.com>
 <CAMbWs48eE-s-jCicC8pSVfXk8Ws-ZvUKnsw8qH-DkVBdYv0eJQ@mail.gmail.com>
 <CAMbWs483a7-8M0pDttG44r-+8Gevn9VG0xNceE3WpkEQxJXPZw@mail.gmail.com>
 <CAHewXNmYM6DvR_kaxDL0w0fz9BwKbac+TSU3QS10aA3cXHyMmA@mail.gmail.com>
 <CA+TgmoaxH=P63hLYgyJJcEbMRnw3xi16d=HxFi1j-m7MhH6W_w@mail.gmail.com>
 <CAMbWs4_cOnpGsywj9Jt1WAgzJLW9Rxt5X13cfGz4iN2qvZQ68g@mail.gmail.com>
 <CA+Tgmob0q7bRbsFTVDMjxHE6zA4uDQLQa-s0CtwUw49V53UL_A@mail.gmail.com>
 <CAMbWs4-Xru_eKBeRHFduigSGihdixFWVTR8A+dtMw7Mao+RkJA@mail.gmail.com>
 <CAMbWs49dLjSSQRWeud+KSN0G531ciZdYoLBd5qktXA+3JQm_UQ@mail.gmail.com>
 <CAMbWs48LXGC-Y63YtzEeM-3f0NUXWCUEMs7XwGzywXTjUNMcxQ@mail.gmail.com>
 <CAMbWs48XdzvnwfTHWxQ7qK-yjvdrbwsPpqhJBuKDnO+hcbsVwA@mail.gmail.com>
 <CA+TgmoaO-7RHdyJuizWChXZm7EJGvDcfoePDDEyUA-y8vTB1tg@mail.gmail.com>
 <CAMbWs4-+jXRpKuFMZa08bS34-TBka3qqjVMAUjF=-1RA9BKvgg@mail.gmail.com>
 <CA+TgmoZapU1y59-s3o8oPt7Hv+cxRh_34FMu6MXumomLe+U1Cw@mail.gmail.com>
 <CAMbWs4_sEeeBmucBzbamBMfA9uLxVmOc_MV=ZpSyDbTcrUO_XQ@mail.gmail.com>
 <CA+Tgmob4fnv57PQB0Oox86mHSJQ0vVL249eT=gqPvrMkG7h1zw@mail.gmail.com>
 <CAMbWs489NYyTcCTbrUi7hPXKtNY5vHrrFcHyMRAv=CA5WsszVw@mail.gmail.com>
 <CA+TgmoazmDdcc7NeTo3WM5HW3DASNP4rfZw6X+2nnQKHampOng@mail.gmail.com>
 <CAMbWs49bYr-ULhA+-At0iQ+NaFKy72AWB6jzughk8MPTiY+gMQ@mail.gmail.com>
 <CA+TgmoYa-zexdbc5nO_D6oxPMZYs06hkYwZK5Dufq+4Hhe6uNQ@mail.gmail.com>
 <CAMbWs4_aji0kME490phz6nTXnPToddUn19OF3rLm1g4TbNkuzQ@mail.gmail.com>
 <CA+Tgmoa3+G_=8XuQWN+0ugv6r-WV6ruFESpOxpXAAKrne3oVDQ@mail.gmail.com>
 <CAMbWs49qiox13EKb7bqgLu7Gu9oar+xe6KMwBjgFwod3JzPfUw@mail.gmail.com>
 <CAMbWs48F8WGA-Lzj1Dk76mFqRFxPEwG2_9Zb7+pFs8oi6ew2pw@mail.gmail.com>
 <CAMbWs484ms=WRZamOyWnVditREKFqipLsdaQjcv2uKur8SZuqw@mail.gmail.com>
 <CAMbWs49bL2ZMSc0W4G8=R7bjaa-vO6grucEOFYLZFUZE7+nzrQ@mail.gmail.com>
 <CA+TgmobqbeJ9iRQO4ym6OiHt71sSv2eai=01kOZjxhdof9K4Mw@mail.gmail.com>
 <CAMbWs4_2BzuAX+BSO1p7rtUwmQjORrG-b906Cw-RkfRjFP0oSQ@mail.gmail.com>
 <CA+TgmoYbkvYwLa+1vOP7RDY7kO2=A7rppoPusoRXe44VDOGBPg@mail.gmail.com>
 <CAMbWs4_aezTYOZSj7v+aypLo0dnjAierJtdx2gf6se28p88WHg@mail.gmail.com>
 <CA+TgmoaY6E5-UFTWp5BtAjBO=tDQd=UVAgeJ3dRbFFzhnP5NHg@mail.gmail.com>
 <CAMbWs484dnecwXT2WzWFvzEmWPzC3U9F8SRDXg-SEegTYUFyXQ@mail.gmail.com>
 <CAMbWs4-2cVfBk1HNGtqV1QFo2yKnzdxLy0BAqQaJHBt+8+kspw@mail.gmail.com>
In-Reply-To: 
 <CAMbWs4-2cVfBk1HNGtqV1QFo2yKnzdxLy0BAqQaJHBt+8+kspw@mail.gmail.com>
From: Richard Guo <guofenglinux@gmail.com>
Date: Mon, 29 Sep 2025 11:09:07 +0900
X-Gm-Features: AS18NWBwseIW0GdsknZf78hO7f5MPhs1TrPmg1TThlklQqvYLnNp8UukTZPUHRo
Message-ID: 
 <CAMbWs48W80HFm9b+yZPKER=MA5M_bveYvBx1AwOrxdPYbLmYmQ@mail.gmail.com>
Subject: Re: Eager aggregation, take 3
To: Robert Haas <robertmhaas@gmail.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, Tender Wang <tndrwang@gmail.com>,
	Paul George <p.a.george19@gmail.com>, Andy Fan <zhihuifan1213@163.com>,
	PostgreSQL-development <pgsql-hackers@postgresql.org>,
 pgsql-hackers@lists.postgresql.org,
	Matheus Alcantara <matheusssilv97@gmail.com>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
List-Id: <pgsql-hackers.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-hackers@lists.postgresql.org>
List-Owner: <mailto:pgsql-hackers-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-hackers>
Archived-At: 
 <https://www.postgresql.org/message-id/CAMbWs48W80HFm9b%2ByZPKER%3DMA5M_bveYvBx1AwOrxdPYbLmYmQ%40mail.gmail.com>
Precedence: bulk

On Thu, Sep 25, 2025 at 1:23=E2=80=AFPM Richard Guo <guofenglinux@gmail.com=
> wrote:
> Attached is an updated version of the patch with these optimizations
> applied.

FWIW, I plan to do another self-review of this patch soon, with the
goal of assessing whether it's ready to be pushed.  If anyone has any
concerns about any part of the patch or would like to review it, I
would greatly appreciate hearing from you.

- Richard