Tobias Brox <[EMAIL PROTECTED]> writes:
> This query puzzles me:
> select * from game where game_end>'2005-07-30' and state in (3,4);
> ...
> Now, how can the planner believe the game_by_state-index to be better?
I suspect the problem has to do with lack of cross-column statistics.
The planner d
[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 ma
why not simply create an index on (game_end, state) ?
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
