Re: BUG #19102: Assertion failure in generate_orderedappend_paths with aggregate pushdown - Mailing list pgsql-bugs

From Kuntal Ghosh
Subject Re: BUG #19102: Assertion failure in generate_orderedappend_paths with aggregate pushdown
Date
Msg-id CAGz5QCLVjZBbM65E5Wkox3gO9wcLK6nwxe=GpJ6LCS3_7C_NnQ@mail.gmail.com
Whole thread Raw
In response to Re: BUG #19102: Assertion failure in generate_orderedappend_paths with aggregate pushdown  (Richard Guo <guofenglinux@gmail.com>)
List pgsql-bugs
On Tue, Nov 4, 2025 at 1:14 PM Richard Guo <guofenglinux@gmail.com> wrote:
Here are the updated patches.  I split the changes into two: 0001
fixes the Assert failure and updates the out-of-date comment for
generate_orderedappend_paths(), while 0002 addresses the second and
third issues I described upthread.

The assertion failure also exists in v18, so I think it would be best
to get 0001 pushed and backpatched before the code freeze.  I'm not
sure whether 0002 should be backpatched.  Before that, I'd like to
know whether these two patches make sense.
Thanks for the patch.

The fix for the assert failure looks good to me. And, yes, it would be good to backpatch this before the code freeze.

--
Thanks & Regards,
Kuntal Ghosh

pgsql-bugs by date:

Previous
From: Michael Paquier
Date:
Subject: Re: BUG #19093: Behavioral change in walreceiver termination between PostgreSQL 14.17 and 14.18
Next
From: PG Bug reporting form
Date:
Subject: BUG #19103: Canceled INSERT statement can still influence the performance of subsequent SELECT statement