Horton

Re: query optimiser changes 6.5->7.0

Joseph S <jks@selectacast.net>

View thread View on postgr.es
From: Joseph Shraibman <jks@selectacast.net>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Simon Hardingham <simon@netxtra.net>, pgsql-general@postgresql.org
Date: 2000-06-02T04:23:05Z
Lists: 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?