Re: Expected performance of querying 5k records from 4 million records?

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Anish Kejariwal <anishkej(at)gmail(dot)com>
Cc: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Expected performance of querying 5k records from 4 million records?
Date: 2012-06-18 19:08:37
Message-ID: 4FDF7CB5.4060207@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Strange, John W 2012-06-19 16:00:51 pgbouncer - massive overhead?
Previous Message Samuel Gendler 2012-06-18 16:49:39 Re: Expected performance of querying 5k records from 4 million records?