Re: partial index regarded more expensive

From: Tobias Brox
Subject: Re: partial index regarded more expensive
Date: ,
Msg-id: 20050810183142.GG6141@tobias.lan
(view: Whole thread, Raw)
In response to: Re: partial index regarded more expensive  (PFC)
List: pgsql-performance

Tree view

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 by date:

From: "Joshua D. Drake"
Date:
Subject: Re: Speedier count(*)
From: Michael Fuhr
Date:
Subject: Re: Speedier count(*)