Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 94D539FB91D for ; Tue, 5 Jun 2007 10:24:50 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 71335-01-6 for ; Tue, 5 Jun 2007 10:24:27 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from cassarossa.samfundet.no (cassarossa.samfundet.no [129.241.93.19]) by postgresql.org (Postfix) with ESMTP id 366689FBCAB for ; Tue, 5 Jun 2007 10:16:51 -0300 (ADT) Received: from trofast.sesse.net ([129.241.93.32]) by cassarossa.samfundet.no with esmtp (Exim 4.50) id 1HvYty-0000QU-Kj; Tue, 05 Jun 2007 15:16:46 +0200 Received: from sesse by trofast.sesse.net with local (Exim 3.36 #1 (Debian)) id 1HvYtx-0001aE-00; Tue, 05 Jun 2007 15:16:45 +0200 Date: Tue, 5 Jun 2007 15:16:45 +0200 From: "Steinar H. Gunderson" To: Gauri Kanekar Cc: pgsql-performance@postgresql.org Subject: Re: Performance Problem Message-ID: <20070605131645.GA6051@uio.no> Mail-Followup-To: Gauri Kanekar , pgsql-performance@postgresql.org References: <7e4ba9550706050226u7c2aa291he77dbfbeb90ce815@mail.gmail.com> <7e4ba9550706050253o5d7048c3vbe755eb7fc85d298@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline In-Reply-To: <7e4ba9550706050253o5d7048c3vbe755eb7fc85d298@mail.gmail.com> X-Operating-System: Linux 2.6.20.4 on a x86_64 X-Message-Flag: Outlook? --> http://www.mozilla.org/products/thunderbird/ User-Agent: Mutt/1.5.13 (2006-08-11) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200706/63 X-Sequence-Number: 25096 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/