On 22/06/11 04:34, Tripura wrote:
> Hello All..
> This is my first PostgreSql database. It has 8 tables and 4 tables are very
> huge each with 6million records.
> I have a simple view on this tables and it is taking more than 3hrs to
> return the results.
> Can someone help me the way to improve the db return the results in a faster
and post a follow-up with more detail.
In response to
pgsql-performance by date
|Next:||From: Marti Raudsepp||Date: 2011-06-22 09:55:46|
|Subject: Re: seq scan in the case of max() on the primary key column|
|Previous:||From: Greg Smith||Date: 2011-06-21 22:17:21|
|Subject: Re: Contemplating SSD Hardware RAID|