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)
Список: pgsql-performance

Скрыть дерево обсуждения

partial index regarded more expensive  (Tobias Brox, )
 Re: partial index regarded more expensive  (PFC, )
  Re: partial index regarded more expensive  (Tobias Brox, )
 Re: partial index regarded more expensive  (Tom Lane, )

[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 по дате сообщения:

От: "Joshua D. Drake"
Дата:
Сообщение: Re: Speedier count(*)
От: Michael Fuhr
Дата:
Сообщение: Re: Speedier count(*)