Re: Inefficient filter order in query plan

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Inefficient filter order in query plan
Дата
Msg-id 1633.1393520657@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Inefficient filter order in query plan  (Tom Coogan <nocera@gmail.com>)
Ответы Re: Inefficient filter order in query plan  (Stephen Frost <sfrost@snowman.net>)
Re: Inefficient filter order in query plan  (Tom Coogan <nocera@gmail.com>)
Список pgsql-performance
Tom Coogan <nocera@gmail.com> writes:
> I'd like to understand why PostgreSQL is choosing to filter on the most
> inefficient predicate first in the query below.

It doesn't know that LIKE is any more expensive than the other operators,
so there's no reason to do them in any particular order.

You could try increasing the cost attributed to the texticlike() function
if you don't like the results you're getting here.

            regards, tom lane


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

Предыдущее
От: Tom Coogan
Дата:
Сообщение: Inefficient filter order in query plan
Следующее
От: Stephen Frost
Дата:
Сообщение: Re: Inefficient filter order in query plan