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/
