Request a Demo
Home   >   mailing lists

Re: [EXTERNAL]Re: BUG #19094: select statement on postgres 17 vs postgres 18 is returning different/duplicate results - Mailing list pgsql-bugs

From Richard Guo
Subject Re: [EXTERNAL]Re: BUG #19094: select statement on postgres 17 vs postgres 18 is returning different/duplicate results
Date
Msg-id CAMbWs4_yu8pF+4awmYZDjixnOskRe9e+vbbQpmCy0uSEzeo5Pw@mail.gmail.com
Whole thread Raw
In response to Re: [EXTERNAL]Re: BUG #19094: select statement on postgres 17 vs postgres 18 is returning different/duplicate results  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Tree view 
On Thu, Oct 30, 2025 at 1:00 AM Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Richard Guo <guofenglinux@gmail.com> writes:
> > After spending a bit more time experimenting, I couldn't find a better
> > query that shows a large difference between the costs of the PRSJ plan
> > and the patched version plan.  So I've updated the test case to use
> > the aforementioned one.  I also removed the reset statements and
> > switched to the begin/rollback pattern for the test case.

> v2 patch LGTM.

Thanks for the review.  I've pushed v2 and backpatched it to v18.

Thanks to Lori for the report.

- Richard

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: Thomas Munro
Date:
Subject: Re: [EXTERNAL]Re: BUG #19094: select statement on postgres 17 vs postgres 18 is returning different/duplicate results