Alvaro Herrera <[EMAIL PROTECTED]> writes:
> Tom Lane escribió:
>> What I think you'll find, though, is that once you do force an indexscan
>> to be picked it'll be slower. Full-table index scans are typically
>> worse than seqscan+sort, unintuitive though that may sound.
> Hmm, should we switch the CLUSTER code to do that?
It's been suggested before, but I'm not sure. The case where an
indexscan can win is where the table is roughly in index order already.
So if you think about periodic CLUSTER to maintain table ordering,
I suspect you'd want the indexscan implementation for all but maybe
the first time.
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
