Re: Eager aggregation, take 3

Richard Guo <guofenglinux@gmail.com>

From: Richard Guo <guofenglinux@gmail.com>

To: Matheus Alcantara <matheusssilv97@gmail.com>

Cc: Robert Haas <robertmhaas@gmail.com>, 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

Date: 2025-09-05T07:35:17Z

Lists: pgsql-hackers

Attachments

v21-0001-Implement-Eager-Aggregation.patch (application/octet-stream) patch v21-0001

On Mon, Sep 1, 2025 at 10:32 AM Richard Guo <guofenglinux@gmail.com> wrote:
> This patch needs a rebase; here it is.  No changes were made.

Here is a rebase after the GUC tables change.

- Richard

Commits

Fix eager aggregation for semi/antijoin inner rels
- ffeda04259bb 19 (unreleased) landed
Cover additional errors and corner conditions in repack.c
- 2670cc298f42 19 (unreleased) cited
Fix volatile function evaluation in eager aggregation
- 3a08a2a8b4fd 19 (unreleased) landed
Fix collation handling for grouping keys in eager aggregation
- bd94845e8c90 19 (unreleased) landed
Rename apply_at to apply_agg_at for clarity
- 1206df04c200 19 (unreleased) landed
Fix comment in eager_aggregate.sql
- 36fd8bde1b77 19 (unreleased) landed
Remove unnecessary include of "utils/fmgroids.h"
- f997d777adf7 19 (unreleased) landed
Implement Eager Aggregation
- 8e11859102f9 19 (unreleased) landed
Allow negative aggtransspace to indicate unbounded state size
- 185e30426334 19 (unreleased) landed
Add macros for looping through a List without a ListCell.
- 14dd0f27d7cd 17.0 cited
Account for the effect of lossy pages when costing bitmap scans.
- 5edc63bda68a 11.0 cited
Fix a thinko in join_is_legal: when we decide we can implement a semijoin
- a43b190e3c71 9.0.0 cited