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 47213925D93 for ; Fri, 30 May 2003 18:59:42 -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 33532-03 for ; Fri, 30 May 2003 18:59:40 -0400 (EDT) Received: from louise.pinerecords.com (louise.pinerecords.com [213.168.176.16]) by developer.postgresql.org (Postfix) with ESMTP id 3EC97925D3E for ; Fri, 30 May 2003 18:59:40 -0400 (EDT) Received: from louise.pinerecords.com (kala@localhost [127.0.0.1]) by louise.pinerecords.com with ESMTP id h4UMxdvI024661 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Sat, 31 May 2003 00:59:39 +0200 Received: (from kala@localhost) by louise.pinerecords.com (submit) id h4UMxd45024660; Sat, 31 May 2003 00:59:39 +0200 Date: Sat, 31 May 2003 00:59:39 +0200 From: Tomas Szepe To: Tom Lane Cc: pgsql-bugs@postgresql.org Subject: Re: db growing out of proportion Message-ID: <20030530225939.GE21944@louise.pinerecords.com> References: <8938.1054300299@sss.pgh.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <8938.1054300299@sss.pgh.pa.us> User-Agent: Mutt/1.4.1i X-Virus-Scanned: by amavisd-new X-Archive-Number: 200305/118 X-Sequence-Number: 6079 > [tgl@sss.pgh.pa.us] > > Peter Childs writes: > > On Fri, 30 May 2003, Tomas Szepe wrote: > >> Trouble is, as the rows in the tables get deleted/inserted/updated > >> (the frequency being a couple thousand rows per minute), the database > >> is growing out of proportion in size. > > > Would more regular vacuum help. I think a vaccum every hour may do > > the job. > > Also note that no amount of vacuuming will save you if the FSM is not > large enough to keep track of all the free space. The default FSM > settings, like all the other default settings in Postgres, are set up > for a small installation. You'd probably need to raise them by at least > a factor of 10 for this installation. Thanks, I'll try to tweak those settings and will let the list know how things went. -- Tomas Szepe