Re: query optimiser changes 6.5->7.0

Martijn van Oosterhout wrote:

> > set enable_seqscan=off;
> 
> But doesn't this mean that if there are no appropriate
> indicies defined on a table, queries will fail?

no, it just makes sequential scans a very bad choice.  of course, if
there aren't any other choices, you're stuck going with the bad choice.
that means that if there aren't any other options (i.e. indexes) you'll
always revert to a sequential scan.

jeff