Re: intercepting where clause on a view or other performance tweak

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: intercepting where clause on a view or other performance tweak
Дата
Msg-id 15097.1353080505@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: intercepting where clause on a view or other performance tweak  (Russell Keane <Russell.Keane@inps.co.uk>)
Список pgsql-performance
Дерево обсуждения 
Russell Keane <Russell.Keane@inps.co.uk> writes:
> Sorry, I should've added that in the original description.
> I have an index on search_key and it's never used.

Did you pay attention to the point about the nondefault operator class?
If the LIKE pattern is left-anchored and as selective as your example
implies, the planner certainly ought to try to use a compatible index.

            regards, tom lane

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

Предыдущее
От: Russell Keane
Дата:
Сообщение: Re: intercepting where clause on a view or other performance tweak
Следующее
От: Craig James
Дата:
Сообщение: Re: PostgreSQL strange query plan for my query