Re: Replace IN VALUES with ANY in WHERE clauses during optimization - Mailing list pgsql-hackers

From Alexander Korotkov
Subject Re: Replace IN VALUES with ANY in WHERE clauses during optimization
Date
Msg-id CAPpHfdstLSmHE+JiuHVsY2LatzOaCwCvBcsGy7vSFawGy0yStA@mail.gmail.com
Whole thread Raw
In response to Re: Replace IN VALUES with ANY in WHERE clauses during optimization  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Fri, Apr 4, 2025 at 7:00 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Peter Geoghegan <pg@bowt.ie> writes:
> > Is somebody going to commit this soon? Alexander?
>
> Done.
>
> I thought the point of the test case was to check VALUES folding
> on both sides of the join.  I'm not sure why that's actually
> a useful expenditure of test cycles, but Alena's patch undid that
> without adjusting the comment claiming that's what it's doing.
> So I kept the shape of the test the same while substituting
> hopefully-stabler tables as she did.
>
> If it's still not stable I think the next step is to nuke both
> test queries, since I remain of the opinion that they're likely
> a waste of cycles.

Thank you for pushing this!  I just start looking at the problem and
have just seen your commit.

------
Regards,
Alexander Korotkov
Supabase



pgsql-hackers by date:

Previous
From: vignesh C
Date:
Subject: Re: Fwd: [BUG]: the walsender does not update its IO statistics until it exits
Next
From: Andres Freund
Date:
Subject: Re: Test to dump and restore objects left behind by regression