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 1v6flq-0080f2-Vs for pgsql-hackers@arkaria.postgresql.org; Thu, 09 Oct 2025 01:48:43 +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 1v6flo-00EPnX-P0 for pgsql-hackers@arkaria.postgresql.org; Thu, 09 Oct 2025 01:48:41 +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 1v6flo-00EPnM-Fd for pgsql-hackers@lists.postgresql.org; Thu, 09 Oct 2025 01:48:41 +0000 Received: from mail-yw1-x1135.google.com ([2607:f8b0:4864:20::1135]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1v6flm-000lbD-0y for pgsql-hackers@postgresql.org; Thu, 09 Oct 2025 01:48:40 +0000 Received: by mail-yw1-x1135.google.com with SMTP id 00721157ae682-77f947312a5so4461397b3.2 for ; Wed, 08 Oct 2025 18:48:39 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1759974518; x=1760579318; darn=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=3M+CNpT122iFW4GRmNMdRAoyoalgtgSAUWO+gZ199to=; b=bEGY9vssacgZOTfjQL3ZSOBa6kF6q1H+STaXFcdqlwXdRGEf59AL1AZZeBu9IMqyfm IgUuD6XpVs+Mkk+DJjICDdTCuFF5QE4fRj+1X2CaF6HiYQdwtUr1YfVvXK6TOdBDWGv0 53b8Elo0IQCQg0HO7XARbFZO3avYKmikSeFyZc2Fs1C1nozyQEKii3eMGy6zpvoXsF9N 1//NR2jdM4pq0bDryzK6IjFf+PAULkslngkxthwa8n5DwkE15M3C055aCEd6zQHu4rfE JF9+btxmLwaulgq9h2C+uMkdJVgIjLnC6MyByr0GW2Zazrlqya7yyIDNdVTSS4ddDRfR IYEg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1759974518; x=1760579318; 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=3M+CNpT122iFW4GRmNMdRAoyoalgtgSAUWO+gZ199to=; b=SufKRYuWGoJKyo1XyO/cpRPy9F1HHE3Hr628EOzaB+/Cf9jfNB0ol9V6ka3BlT2rGE FAiEwjfSNMo+sAAoZrUyvkI5uxX+1wGGBfWZzVufcR6IEuaMy4/HYSh3Z3OaBuN/I1oz diS956TURa1hH7WPkLMuVR43AZTBdykpt+IvkljDurLDppKtkIwZacNpTsnIUWWiq8j5 ll66rxXFwPwq1ZBSvQmMxrKSSL0BEuY/vpCgi50z4JSvWCL8rYqeSQjNYgsASlBFbZDn PwsyPHm5zD2RqQFc8VFg3/sj55wko87ueoMhniwt0Qe49HcPnQ3DXiI4Ak1T7TLwHxUZ iWcQ== X-Forwarded-Encrypted: i=1; AJvYcCVySSaWJArC6Emq13xHzahOuFazmlwQ96UOtydn/a1bJ+T9OutBGT/npEA4djC4hAj1g0JrE8n5q9miA346@postgresql.org X-Gm-Message-State: AOJu0YzZ5e3n83Qk69i+CKXVz9PZSV7Ts7iLJPhwKPUTmRlXv8m5eXAu MsvGVbJMJKxz026tDW61qnRRYX/RcE+cbNXe9O4gldfYK60KKwVPIFi0rBJTeFs0qFbgl8CFGxr KJ+3M65KRHSZccVFOgnp5L0UNXNcifMg= X-Gm-Gg: ASbGnctb+mih270dSEsi/TLIIfwEsM3zpC8SLw8iFVruU0XMZFDULb/m18cU6j8EZsF fjMl/htYu4y45Vl1ZpbK7cvv/V5CKOpkJA5d8GOlzuU4BPJ+Qks4Mmx0poWj/8DmiKjKKY355Bg 1Y8eunDt2FdAalw5MT3CLoFsYHYAiF+PPHBc0PhwLYP1rZ3NcM2efg8jIU1G5OTz+id1XTilfRa N02K9eJmJ7aY4PpzoYu14WPQ96X7uhgkOnarHY3sCZHIyk+y2gRdA== X-Google-Smtp-Source: AGHT+IG8NRnGug6qsWBZBc3uC18R/C0p88f75qCjkhytGUhzSXBf6WV3mq5RrqALPsWdboKVm+oFuC6GSVQifusyq5U= X-Received: by 2002:a53:cb41:0:b0:634:751b:1d13 with SMTP id 956f58d0204a3-63ccb85da27mr4496403d50.23.1759974518416; Wed, 08 Oct 2025 18:48:38 -0700 (PDT) MIME-Version: 1.0 References: <87il22cj51.fsf@163.com> In-Reply-To: From: Richard Guo Date: Thu, 9 Oct 2025 10:48:27 +0900 X-Gm-Features: AS18NWCRlqH-cPW1dQSQLOYWi9bUpQ7Up7U8mYhjcKPZ1TRjyHrITWru8RKa7xM Message-ID: Subject: Re: Eager aggregation, take 3 To: Robert Haas Cc: Tom Lane , Tender Wang , Paul George , Andy Fan , PostgreSQL-development , pgsql-hackers@lists.postgresql.org, Matheus Alcantara Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Mon, Oct 6, 2025 at 9:59=E2=80=AFAM Richard Guo = wrote: > On Mon, Sep 29, 2025 at 11:09=E2=80=AFAM Richard Guo wrote: > > 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. > Barring any objections, I'll plan to push v23 in a couple of days. I've pushed v24 -- thanks for all the reviews! Now bracing for the upcoming bug reports. - Richard