Re: partial index regarded more expensive

From: Tobias Brox <tobias(at)nordicbet(dot)com>
To: PFC <lists(at)boutiquenumerique(dot)com>
Cc: Tobias Brox <tobias(at)nordicbet(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: partial index regarded more expensive
Date: 2005-08-10 18:31:42
Message-ID: 20050810183142.GG6141@tobias.lan
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Ian Westmacott 2005-08-10 21:03:53 Re: Planner doesn't look at LIMIT?
Previous Message PFC 2005-08-10 18:15:13 Re: partial index regarded more expensive