Re: Eager aggregation, take 3 - Mailing list pgsql-hackers

From Richard Guo
Subject Re: Eager aggregation, take 3
Date
Msg-id CAMbWs49KSppYihVGz+c5uKJeRHtaG-a1wTG96d-ZMuEUmTO1Qw@mail.gmail.com
Whole thread
List pgsql-hackers
On Mon, Jun 1, 2026 at 4:57 PM Tender Wang <tndrwang@gmail.com> wrote:
> Richard Guo <guofenglinux@gmail.com> 于2026年6月1日周一 15:19写道:
> > So I'd rather fix it in eager_aggregation_possible_for_relation, right
> > next to the existing outer-join check, by rejecting a relation that
> > lies on the inner side of a semijoin/antijoin.  See attached.

> The attached LGTM.

Thanks for the review.  Pushed.

And thanks to Radim for the report and the well-contained repro.

- Richard



pgsql-hackers by date:

Previous
From: Shinya Kato
Date:
Subject: Re: Report oldest xmin source when autovacuum cannot remove tuples
Next
From: Chao Li
Date:
Subject: Re: Fix bug of CHECK constraint enforceability recursion