X-Original-To: pgsql-bugs@postgresql.org Received: from localhost (developer.postgresql.org [64.117.224.193]) by developer.postgresql.org (Postfix) with ESMTP id 24BF0925D93 for ; Fri, 30 May 2003 19:00:59 -0400 (EDT) Received: from developer.postgresql.org ([64.117.224.193]) by localhost (developer.postgresql.org [64.117.224.193:10024]) (amavisd-new) with ESMTP id 33049-09 for ; Fri, 30 May 2003 19:00:58 -0400 (EDT) Received: from louise.pinerecords.com (louise.pinerecords.com [213.168.176.16]) by developer.postgresql.org (Postfix) with ESMTP id B67D0925D3E for ; Fri, 30 May 2003 19:00:57 -0400 (EDT) Received: from louise.pinerecords.com (kala@localhost [127.0.0.1]) by louise.pinerecords.com with ESMTP id h4UN0pvI024706 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Sat, 31 May 2003 01:00:51 +0200 Received: (from kala@localhost) by louise.pinerecords.com (submit) id h4UN0ojI024705; Sat, 31 May 2003 01:00:50 +0200 Date: Sat, 31 May 2003 01:00:50 +0200 From: Tomas Szepe To: Stephan Szabo Cc: pgsql-bugs@postgresql.org Subject: Re: db growing out of proportion Message-ID: <20030530230050.GF21944@louise.pinerecords.com> References: <20030530072442.GD14159@louise.pinerecords.com> <20030530083944.N91707-100000@megazone23.bigpanda.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20030530083944.N91707-100000@megazone23.bigpanda.com> User-Agent: Mutt/1.4.1i X-Virus-Scanned: by amavisd-new X-Archive-Number: 200305/119 X-Sequence-Number: 6080 > As Tom said, you probably need higher FSM settings, but also, do you have > any long lived transactions (say from some kind of persistent connection > system) that might be preventing vacuum from removing rows? No, not at all. -- Tomas Szepe