| From: | Richard Guo <guofenglinux(at)gmail(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Lori Corbani <Lori(dot)Corbani(at)jax(dot)org>, Thomas Munro <thomas(dot)munro(at)gmail(dot)com>, "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: [EXTERNAL]Re: BUG #19094: select statement on postgres 17 vs postgres 18 is returning different/duplicate results |
| Date: | 2025-10-30 03:24:49 |
| Message-ID: | CAMbWs4_yu8pF+4awmYZDjixnOskRe9e+vbbQpmCy0uSEzeo5Pw@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
On Thu, Oct 30, 2025 at 1:00 AM Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Richard Guo <guofenglinux(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thomas Munro | 2025-10-30 03:43:44 | Re: [EXTERNAL]Re: BUG #19094: select statement on postgres 17 vs postgres 18 is returning different/duplicate results |
| Previous Message | Michael Paquier | 2025-10-29 23:36:43 | Re: BUG #19093: Behavioral change in walreceiver termination between PostgreSQL 14.17 and 14.18 |