Re: Improve the Postgres Query performance

From: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
To: Tripura <k_tripura(at)hotmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Improve the Postgres Query performance
Date: 2011-06-22 07:05:14
Message-ID: 4E01942A.7000402@postnewspapers.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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
> way.

Please read:

http://wiki.postgresql.org/wiki/SlowQueryQuestions

and post a follow-up with more detail.

--
Craig Ringer

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Marti Raudsepp 2011-06-22 09:55:46 Re: seq scan in the case of max() on the primary key column
Previous Message Greg Smith 2011-06-21 22:17:21 Re: Contemplating SSD Hardware RAID