On 6/18/12 9:39 AM, Anish Kejariwal wrote:
> Thanks for the help, Jeff and Josh. It looks reclustering the multi-column
> index might solve things. For my particular query, because I'm getting a
> range of records back, it makes sense that reclustering will benefit me if
> I have a slow disk even if I had expected that the indices would be
> sufficient . I now need to make sure that the speed up I'm seeing is not
> because things have been cached.
Well, other than that your performance is as expected because of your
much-larger-than-RAM database and your relatively slow disk.
--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com