Home > mailing lists

Re: partial index regarded more expensive - Mailing list pgsql-performance

From	Tobias Brox
Subject	Re: partial index regarded more expensive
Date	August 10, 2005 18:32:06
Msg-id	20050810183142.GG6141@tobias.lan Whole thread Raw
In response to	Re: partial index regarded more expensive (PFC <lists@boutiquenumerique.com>)
List	pgsql-performance

Tree view

[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: PFC
Date: 10 August 2005, 18:15:19
Subject: Re: partial index regarded more expensive

From: Ian Westmacott
Date: 10 August 2005, 21:04:09
Subject: Re: Planner doesn't look at LIMIT?

Re: partial index regarded more expensive - Mailing list pgsql-performance

Previous

Next