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

From Alena Rybakina
Subject Re: Replace IN VALUES with ANY in WHERE clauses during optimization
Date
Msg-id b972df06-468b-4e18-9f58-f70abc75415f@postgrespro.ru
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 04.04.2025 19:00, Tom Lane 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.
Yes, that's right. Thank you.
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.
	
Agree.

-- 
Regards,
Alena Rybakina
Postgres Professional

pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: New criteria for autovacuum
Next
From: Fujii Masao
Date:
Subject: Re: Use XLOG_CONTROL_FILE macro everywhere?