Message-ID: <50732EFD.80608@ulb.ac.be>
Date: Mon, 08 Oct 2012 21:52:29 +0200
From: Julien Cigar <jcigar@ulb.ac.be>
User-Agent: Mozilla/5.0 (X11; FreeBSD amd64;
	rv:15.0) Gecko/20120909 Thunderbird/15.0
MIME-Version: 1.0
To: pgsql-performance@postgresql.org
Subject: Re: Scaling 10 million records in PostgreSQL table
References: <b2d0ada9-f13a-4269-b378-1ceaf2451190@googlegroups.com>
In-Reply-To: <b2d0ada9-f13a-4269-b378-1ceaf2451190@googlegroups.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

On 10/08/2012 17:26, Navaneethan R wrote:
> Hi all,

Hello,

>        I have 10 million records in my postgres table.I am running the database in amazon ec2 medium instance. I need to access the last week data from the table.
> It takes huge time to process the simple query.So, i throws time out exception error.
>
> query is :
>       select count(*) from dealer_vehicle_details where modified_on between '2012-10-01' and '2012-10-08' and dealer_id=270001;

please show us an EXPLAIN ANALYZE of the query

> After a lot of time it responds 1184 as count
>
> what are the ways i have to follow to increase the performance of this query?
>   
> The insertion also going parallel since the daily realtime updation.
>
> what could be the reason exactly for this lacking performace?

missing index, wrong configuration, ...
please also note that, generally, all those "cloud stuff" have generally 
very poor I/O performance ..

>
>