Postgres Pro
Downloads
Home   >   mailing lists

Scaling 10 million records in PostgreSQL table - Mailing list pgsql-performance

From Navaneethan R
Subject Scaling 10 million records in PostgreSQL table
Date
Msg-id b2d0ada9-f13a-4269-b378-1ceaf2451190@googlegroups.com
Whole thread Raw
Responses Re: Scaling 10 million records in PostgreSQL table  (Merlin Moncure <mmoncure@gmail.com>)
Re: Scaling 10 million records in PostgreSQL table  (Julien Cigar <jcigar@ulb.ac.be>)
Re: Scaling 10 million records in PostgreSQL table  (Larry Rosenman <ler@lerctr.org>)
Re: Scaling 10 million records in PostgreSQL table  (Steve Crawford <scrawford@pinpointresearch.com>)
Re: Scaling 10 million records in PostgreSQL table  (Craig Ringer <ringerc@ringerc.id.au>)
List pgsql-performance
Tree view 
Hi all,

      I have 10 million records in my postgres table.I am running the database in amazon ec2 medium instance. I need to
accessthe 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;

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?

pgsql-performance by date:

Previous
From: Andrzej Zawadzki
Date:
Subject: Re: Strange behavior after upgrade from 9.0 to 9.2
Next
From: Merlin Moncure
Date:
Subject: Re: Scaling 10 million records in PostgreSQL table