Postgres Pro
Downloads
Home   >   mailing lists

Re: Improve the Postgres Query performance - Mailing list pgsql-performance

From Craig Ringer
Subject Re: Improve the Postgres Query performance
Date
Msg-id 4E01942A.7000402@postnewspapers.com.au
Whole thread Raw
In response to Improve the Postgres Query performance  (Tripura <k_tripura@hotmail.com>)
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: Tripura
Date:
Subject: Improve the Postgres Query performance
Next
From: Marti Raudsepp
Date:
Subject: Re: seq scan in the case of max() on the primary key column