Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id D9B579F9DB5 for ; Tue, 11 Sep 2007 20:04:31 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 68202-05 for ; Tue, 11 Sep 2007 20:04:20 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from noel.decibel.org (noel.decibel.org [67.100.216.10]) by postgresql.org (Postfix) with ESMTP id 95DBF9F9DB2 for ; Tue, 11 Sep 2007 20:04:24 -0300 (ADT) Received: by noel.decibel.org (Postfix, from userid 1001) id 06FF7564BB; Tue, 11 Sep 2007 23:04:23 +0000 (UTC) Received: (hashcash-sendmail, from uid 1001); Tue, 11 Sep 2007 18:04:21 -0500 Date: Tue, 11 Sep 2007 18:04:21 -0500 From: Decibel! To: Kevin Kempter Cc: pgsql-performance@postgresql.org Subject: Re: More Vacuum questions... Message-ID: <20070911230420.GI38801@decibel.org> References: <200709111024.58444.kevin@kevinkempterllc.com> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="vgR9NaMwtk/oK4d5" Content-Disposition: inline In-Reply-To: <200709111024.58444.kevin@kevinkempterllc.com> X-Operating-System: FreeBSD 6.1-RELEASE-p10 amd64 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.13 (2006-08-11) X-Hashcash: 1:20:070911:kevin@kevinkempterllc.com::QAgT6UHp0+p9cuG3:000000000000 0000000000000000000000001dht X-Hashcash: 1:20:070911:pgsql-performance@postgresql.org::hrsKXu7RKbwyIRhp:00000 0000000000000000000000009NAT X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200709/208 X-Sequence-Number: 26753 --vgR9NaMwtk/oK4d5 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Tue, Sep 11, 2007 at 10:24:58AM -0600, Kevin Kempter wrote: > I let the cron vacuum run for 14 days. in that 14 days the time it takes = to=20 > vacuum the table grew from 1.2hours directly after the rebuild to > 8hour= s=20 > last nite. Sounds to me like daily isn't enough, and that your FSM is too small. --=20 Decibel!, aka Jim Nasby decibel@decibel.org EnterpriseDB http://enterprisedb.com 512.569.9461 (cell) --vgR9NaMwtk/oK4d5 Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.3 (FreeBSD) iD8DBQFG5x70dO30qud8SkgRAubUAJ9RSQVKyM3/15ExiZfHJzvubl47bQCg0RxR KUT9oUzo8YgA1lYAk/92hwI= =/ej5 -----END PGP SIGNATURE----- --vgR9NaMwtk/oK4d5--