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 7631692341F for ; Fri, 30 May 2003 23:21:45 -0400 (EDT) Received: from developer.postgresql.org ([64.117.224.193]) by localhost (developer.postgresql.org [64.117.224.193]) (amavisd-new, port 10024) with ESMTP id 51033-06 for ; Fri, 30 May 2003 23:21:35 -0400 (EDT) Received: from chaos.mshome.net (unknown [148.64.8.86]) by developer.postgresql.org (Postfix) with ESMTP id 37CAD923221 for ; Fri, 30 May 2003 23:21:32 -0400 (EDT) Received: from localhost.localdomain (thunder.mshome.net [192.168.0.250]) by localhost.mshome.net (Postfix) with ESMTP id 6D2691C0551 for ; Fri, 30 May 2003 21:21:24 -0600 (MDT) Received: from logicalchaos.org (thunder.mshome.net [192.168.0.250]) by chaos.mshome.net (Postfix) with SMTP id DBD021C0551 for ; Fri, 30 May 2003 21:21:01 -0600 (MDT) Date: Fri, 30 May 2003 21:21:01 -0600 From: Robert Creager To: pgsql-bugs@postgresql.org Subject: Re: db growing out of proportion Message-Id: <20030530212101.37cef86f.Robert_Creager@LogicalChaos.org> In-Reply-To: <8938.1054300299@sss.pgh.pa.us> References: <8938.1054300299@sss.pgh.pa.us> Organization: Starlight Vision, LLC. X-Mailer: Sylpheed version 0.8.11claws (GTK+ 1.2.10; i686-pc-linux-gnu) Mime-Version: 1.0 Content-Type: multipart/signed; protocol="application/pgp-signature"; micalg="pgp-sha1"; boundary="=.)Ka4uEls(Ax2_3" X-Spam-Checker-Version: SpamAssassin 2.53 (1.174.2.15-2003-03-30-exp) X-Virus-Scanned: by amavisd-new X-Archive-Number: 200305/121 X-Sequence-Number: 6082 --=.)Ka4uEls(Ax2_3 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit On Fri, 30 May 2003 09:11:39 -0400 Tom Lane said something like: > > 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. > Tom, Thanks for the hint. I just upped my shared_buffers to 8192, fsm_relations to 10000, fsm_pages to 100000, sort_mem to 64000, and an UPDATE which was taking over 2 hours dropped down to 1 to 2 minutes! Nice... Thanks, Rob --=.)Ka4uEls(Ax2_3 Content-Type: application/pgp-signature -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.1 (GNU/Linux) iEYEARECAAYFAj7YH50ACgkQgy51bQc2FFlZ7ACdEVN2enTsN+5ERP759DH4qtEu ExQAoNVwIXCopBaRq+YOTcK49UhJME0z =7wj2 -----END PGP SIGNATURE----- --=.)Ka4uEls(Ax2_3--