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

From Joseph Shraibman
Subject Re: query optimiser changes 6.5->7.0
Date
Msg-id 393736A9.ECF133AC@selectacast.net
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
Tom Lane wrote:
>
> Also, 7.0.1, propagating now to an archive near you, contains some
> fudge-factor twiddling to make it more willing to choose an indexscan.
> We shall soon find out whether that made things better or worse for
> typical uses...
>
>                         regards, tom lane

OK this may seem like a stupid question, but isn't index scan always
better except for the pathalogical simple case where the work to be done
is trivial anyway?

pgsql-general by date:

Previous
From: efinley@efinley.com (Elliot Finley)
Date:
Subject: Re: btree index and max()
Next
From: Thomas Good
Date:
Subject: Re: Perl interfaces?