Thread: Re: Replace IN VALUES with ANY in WHERE clauses during optimization

Re: Replace IN VALUES with ANY in WHERE clauses during optimization

From
newtglobal postgresql_contributors
Date:
The following review has been posted through the commitfest application:
make installcheck-world:  tested, failed
Implements feature:       tested, failed
Spec compliant:           tested, failed
Documentation:            tested, failed

Hi Ivan Kush
I tested the patch with `commands.sql` and observed noticeable improvements in planning and execution time, especially
withmultiple tables. Even single-table queries show small time reductions (0.02–0.04 ms). The patch optimizes `IN`
clauseseffectively, particularly with `VALUES`. For example, `col IN (VALUES ('a'), ('b'), ('c'))` now behaves
similarlyto `col IN ('a', 'b', 'c')`, leading to faster execution and reduced planning overhead. 
 
Regards, 
Postgresql Contributors - NewtGlobal