Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 8524E9F9BE9 for ; Tue, 11 Sep 2007 04:31:28 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 48276-02 for ; Tue, 11 Sep 2007 04:31:26 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from proxy2.bredband.net (proxy2.bredband.net [195.54.101.72]) by postgresql.org (Postfix) with ESMTP id 0B2DD9F9C19 for ; Tue, 11 Sep 2007 04:31:25 -0300 (ADT) Received: from zigo.dhs.org (83.227.204.174) by proxy2.bredband.net (7.3.127) id 46E503120006F1FB; Tue, 11 Sep 2007 09:31:23 +0200 Received: from zigo.dhs.org (zigo [127.0.0.1]) by zigo.dhs.org (Postfix) with ESMTP id 7650F8640; Tue, 11 Sep 2007 09:31:23 +0200 (CEST) Received: from 192.121.104.48 (SquirrelMail authenticated user db) by zigo.dhs.org with HTTP; Tue, 11 Sep 2007 09:31:23 +0200 (CEST) Message-ID: <43393.192.121.104.48.1189495883.squirrel@zigo.dhs.org> In-Reply-To: <46E636CB.8080008@rentalia.com> References: <46E636CB.8080008@rentalia.com> Date: Tue, 11 Sep 2007 09:31:23 +0200 (CEST) Subject: Re: [Again] Postgres performance problem From: db@zigo.dhs.org To: "Ruben Rubio" Cc: pgsql-performance@postgresql.org User-Agent: SquirrelMail/1.4.8 MIME-Version: 1.0 Content-Type: text/plain;charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Priority: 3 (Normal) Importance: Normal X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200709/173 X-Sequence-Number: 26718 > Last time I had this problem i solved it stopping website, restarting > database, vacuumm it, run again website. But I guess this is going to > happen again. > > I would like to detect and solve the problem. Any ideas to detect it? Do you have very long transactions? Maybe some client that is connected all the time that is idle in transaction? /Dennis