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

Поиск
Список
Период
Сортировка
От newtglobal postgresql_contributors
Тема Re: Replace IN VALUES with ANY in WHERE clauses during optimization
Дата
Msg-id 174065454278.654.1011593946047422922.pgcf@coridan.postgresql.org
обсуждение исходный текст
Список 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 по дате отправления: