On Tue, Jun 05, 2007 at 03:23:35PM +0530, Gauri Kanekar wrote:
> Befor doing vaccum full on the database this query use to take less
> than 4min. But now after doing vacumming reindexing the tables it is
> taking 73mins.

Did you analyze the table recently? Some of the selectivity estimates seem
quite a bit off -- you could try raising the statistics target.

/* Steinar */
--
Homepage: http://www.sesse.net/

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly