Old-style OR indexscan slated for destruction

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Old-style OR indexscan slated for destruction
Дата
Msg-id 17986.1114368101@sss.pgh.pa.us
обсуждение исходный текст
Ответы Re: Old-style OR indexscan slated for destruction  (Oleg Bartunov <oleg@sai.msu.su>)
Список pgsql-hackers
I am about to rip out the code that supports multiple indexscans for OR
conditions inside a single IndexScan plan node.  As best I can tell,
the new-style bitmap-OR code is as fast or faster than the old way
even in fully cached test cases (ie, with no allowance for improved
efficiency of disk access).  So there's no percentage in maintaining
support for the old way, and getting rid of it will allow simplification
of code and data structures in the planner.
        regards, tom lane


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Re: [PERFORM] Bad n_distinct estimation; hacks suggested?
Следующее
От: Josh Berkus
Дата:
Сообщение: Re: W[i/e]rd performance issue with 8.1cvs