Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group