Re: issues with eager aggregation - Mailing list pgsql-hackers

From Richard Guo
Subject Re: issues with eager aggregation
Date
Msg-id CAMbWs49dEz5y-fiPbvO58T8R3SEz3+nryRp0YVtruFNoegXtzw@mail.gmail.com
Whole thread
In response to Re: issues with eager aggregation  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: issues with eager aggregation
List pgsql-hackers
On Fri, Sep 18, 2026 at 12:55 AM Robert Haas <robertmhaas@gmail.com> wrote:
> On Thu, Sep 17, 2026 at 10:58 AM Richard Guo <guofenglinux@gmail.com> wrote:
> > As for the division-by-zero case, I agree it's user-visible, but I
> > think eager aggregation should follow the same rules as our existing
> > transformations, which already evaluate expressions on rows that a
> > join removes.

> OK, good. So this isn't really doing something that is fundamentally
> new, which is what I was fearing. Do you think this section should be
> adjusted at all?

Yes, I think it's worth saying that an expression can be evaluated on
rows that don't appear in the result.

- Richard



pgsql-hackers by date:

Previous
From: Sami Imseih
Date:
Subject: Re: Reject WAIT FOR earlier in transaction-snapshot mode
Next
From: Tomas Vondra
Date:
Subject: Re: issues with eager aggregation