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 F2573923577 for ; Fri, 30 May 2003 09:13:35 -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 93316-02 for ; Fri, 30 May 2003 09:12:37 -0400 (EDT) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by developer.postgresql.org (Postfix) with ESMTP id A98669235BA for ; Fri, 30 May 2003 09:11:44 -0400 (EDT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.9/8.12.9) with ESMTP id h4UDBdU6008939 for ; Fri, 30 May 2003 09:11:39 -0400 (EDT) To: pgsql-bugs@postgresql.org Subject: Re: db growing out of proportion In-reply-to: References: Comments: In-reply-to Peter Childs message dated "Fri, 30 May 2003 10:21:51 +0100" Date: Fri, 30 May 2003 09:11:39 -0400 Message-ID: <8938.1054300299@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new X-Archive-Number: 200305/114 X-Sequence-Number: 6075 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. regards, tom lane