Replace IN VALUES with ANY in WHERE clauses during optimization

git remote add commitfest https://github.com/postgresql-cfbot/postgresql.git
git fetch commitfest cf/5283
git checkout commitfest/cf/5283

Replace IN VALUES with ANY in WHERE clauses during optimization ×

First at 2024-10-03 19:52:48 by Ivan Kush <ivan.kush at tantorlabs.com>
Latest at 2024-11-11 17:29:14 by Ivan Kush <ivan.kush at tantorlabs.com>
Latest attachment (0001-Introduce-VALUES-ARRAY-transformation.patch) at 2024-10-04 09:05:01 from Andrei Lepikhov <lepihov at gmail.com>

    Attachment (0001-Introduce-VALUES-ARRAY-transformation.patch) at 2024-10-04 09:05:01 from Andrei Lepikhov <lepihov at gmail.com> (Patch: Yes)
    Attachment (commands.sql) at 2024-10-03 19:52:48 from Ivan Kush <ivan.kush at tantorlabs.com> (Patch: No)

Annotations

When	Who	Mail	Annotation
2024-12-11 03:49:41	newtglobal postgresql_contributors (newtpostgrescontributors)	From Ivan Kush <ivan.kush@tantorlabs.com> at 2024-10-03 19:52:48	I tested the patch with `commands.sql` and observed noticeable improvements in planning and execution time, especially with multiple tables. Even single-table queries show small time reductions (0.02–0.04 ms). The patch optimizes `IN` clauses effectively, particularly with `VALUES`. For example, `col IN (VALUES ('a'), ('b'), ('c'))` now behaves similarly to `col IN ('a', 'b', 'c')`, leading to faster execution and reduced planning overhead. Regards, Postgresql Contributors - NewtGlobal ×