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