Re: where+orderby+limit not (always) using appropriate index?

Поиск
Список
Период
Сортировка
От PFC
Тема Re: where+orderby+limit not (always) using appropriate index?
Дата
Msg-id op.sqy79pi8th1vuj@localhost
обсуждение исходный текст
Ответ на where+orderby+limit not (always) using appropriate index?  (Szűcs Gábor <surrano@gmail.com>)
Список pgsql-performance
Дерево обсуждения 

> SELECT o FROM t WHERE i = 1 ORDER BY o LIMIT 1;

    use :
    ORDER BY i, o

    If you have a multicol index and want to order on it, you should help the
planner by ORDERing BY all of the columns in the index...
    It bit me a few times ;)

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