On 8 Apr 2002, Bill Gribble wrote:
> On Mon, 2002-04-08 at 07:45, Martijn van Oosterhout wrote:
> > "Properly" in your opinion. It's more likely that postgres has a better idea
> > of which one is faster...
>
> This seems to be the standard response to any message questioning the
> query planner's strategy.
Perhaps you missed the part of his message where he asks for more
information and gives a short reason why it *might* be choosing
sequence scan?
(quoted from Martijn's message)
"How many rows are there in the table? If you're going to match most of
the table, it's faster to scan the entire table than it is the scan the
index."