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 -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
