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

From newtglobal postgresql_contributors
Subject Re: Replace IN VALUES with ANY in WHERE clauses during optimization
Date
Msg-id 174065454278.654.1011593946047422922.pgcf@coridan.postgresql.org
Whole thread Raw
List pgsql-hackers
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

pgsql-hackers by date:

Previous
From: Ranier Vilela
Date:
Subject: Re: Fix api misuse (src/bin/pg_amcheck/pg_amcheck.c)
Next
From: newtglobal postgresql_contributors
Date:
Subject: Re: New "raw" COPY format