I have a table with a number of columns.
order by a,b
There is an index on a,b which is clustered (as well as indexes on a and b
I have issued the cluster and anyalze commands.
Nevertheless, PostgreSQL performs a Sequential Scan on the table and then
performs a sort.
Am I missing something?
pgsql-performance by date
|Next:||From: Thom Brown||Date: 2009-11-22 13:10:26|
|Subject: Re: Why is the query not using the index for sorting?|
|Previous:||From: afancy||Date: 2009-11-22 09:02:20|
|Subject: Re: Performance degrade running on multicore computer|