Re: query optimiser changes 6.5->7.0 - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: query optimiser changes 6.5->7.0
Date
Msg-id 3937C959.60CDC9EC@cupid.suninternet.com
Whole thread Raw
In response to query optimiser changes 6.5->7.0  ("Simon Hardingham" <simon@netxtra.net>)
Responses Re: query optimiser changes 6.5->7.0  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Alfred Perlstein wrote:
>
> * Wim Ceulemans <wim.ceulemans@nice.be> [000602 02:33] wrote:
> >
> > Isn't there a way to tell the optimizer to use an index scan if one
> > knows this is going to be the best.
>
> set enable_seqscan=off;

But doesn't this mean that if there are no appropriate
indicies defined on a table, queries will fail?
--
Martijn van Oosterhout <kleptog@cupid.suninternet.com>
http://cupid.suninternet.com/~kleptog/

pgsql-general by date:

Previous
From: Ed Loehr
Date:
Subject: Re: client/server? odbc?
Next
From: Ed Loehr
Date:
Subject: Re: Locking Level