[PERFORM] Scaling 10 million records in PostgreSQL table

2012-10-08 Thread Navaneethan R
Hi all, 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 d

Re: [PERFORM] Scaling 10 million records in PostgreSQL table

2012-10-09 Thread Navaneethan R
On Tuesday, October 9, 2012 1:40:08 AM UTC+5:30, Steve Crawford wrote: > On 10/08/2012 08:26 AM, Navaneethan R wrote: > > > Hi all, > > > > > >I have 10 million records in my postgres table.I am running the > > database in amazon ec2 medium instance.