Re: partial index regarded more expensive

Поиск
Список
Период
Сортировка
От Tobias Brox
Тема Re: partial index regarded more expensive
Дата
Msg-id 20050810183142.GG6141@tobias.lan
обсуждение исходный текст
Ответ на Re: partial index regarded more expensive  (PFC <lists@boutiquenumerique.com>)
Список pgsql-performance
[PFC - Wed at 08:15:13PM +0200]
>     why not simply create an index on (game_end, state) ?

No, the planner prefers to use the partial index (I dropped the index on
game(state)).

--
Tobias Brox, Nordicbet IT dept
This signature has been virus scanned, and is probably safe to read.
This mail may contain confidential information, please keep your eyes closed.

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

Предыдущее
От: PFC
Дата:
Сообщение: Re: partial index regarded more expensive
Следующее
От: Ian Westmacott
Дата:
Сообщение: Re: Planner doesn't look at LIMIT?