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/