[mailto:pgsql-performance-owner(at)postgresql(dot)org] On Behalf Of Matthew
Sent: Monday, November 23, 2009 1:00 PM
To: Jonathan Blitz
Subject: Re: [PERFORM] Why is the query not using the index for sorting?
On Sun, 22 Nov 2009, Jonathan Blitz wrote:
> I have a table with a number of columns.
> I perform
> Select *
> from table
> 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.
Did you analyse *after* creating the index and clustering, or before?
[About NP-completeness] These are the problems that make efficient use of
the Fairy Godmother. -- Computer Science Lecturer
Sent via pgsql-performance mailing list (pgsql-performance(at)postgresql(dot)org)
To make changes to your subscription:
No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 9.0.709 / Virus Database: 270.14.76/2517 - Release Date: 11/22/09
In response to
pgsql-performance by date
|Next:||From: Robert Haas||Date: 2009-11-23 16:47:31|
|Subject: Re: View based upon function won't use index on joins|
|Previous:||From: Matthew Wakeling||Date: 2009-11-23 12:44:05|
|Subject: Re: Query times change by orders of magnitude as DB ages|