Request a Demo
Home   >   mailing lists

Re: Wrong results from join removal with DISTINCT ON + SRF subquery - Mailing list pgsql-hackers

From Kirill Reshke
Subject Re: Wrong results from join removal with DISTINCT ON + SRF subquery
Date
Msg-id CALdSSPhiV4LWBZ27brBa17ZZ8f3UaVZ8sWQXy9eQfsL_cmVUug@mail.gmail.com
Whole thread
In response to Wrong results from join removal with DISTINCT ON + SRF subquery  (Richard Guo <guofenglinux@gmail.com>)
List pgsql-hackers
Tree view 
On Tue, 25 Aug 2026 at 11:24, Richard Guo <guofenglinux@gmail.com> wrote:
>
> On Mon, Aug 24, 2026 at 10:53 AM Richard Guo <guofenglinux@gmail.com> wrote:
> > Thanks for looking at this!  I'll push the patch and back-patch to all
> > supported branches if there are no objections.
>
> Done.
>
> - Richard
>
>

HI
Looks like there is related bug report here
[0] https://www.postgresql.org/message-id/flat/19696-135220dd92659a4e%40postgresql.org

wrong join removal is fixed, but cost estimations are still wrong

--
Best regards,
Kirill Reshke

pgsql-hackers by date:

Previous
From: shihao zhong
Date:
Subject: Re: [Patch] New pg_stat_tablespace view
Next
From: Corey Huinker
Date:
Subject: Re: [PG19][PATCH] Make postgres_fdw statistics import atomic