X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 29CB69FA2DB for ; Mon, 5 Jun 2006 11:44:06 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 07002-05 for ; Mon, 5 Jun 2006 11:43:55 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from noel.decibel.org (noel.decibel.org [67.100.216.10]) by postgresql.org (Postfix) with ESMTP id 9A9929FA111 for ; Mon, 5 Jun 2006 11:43:54 -0300 (ADT) Received: by noel.decibel.org (Postfix, from userid 1001) id 1A01B56440; Mon, 5 Jun 2006 09:43:50 -0500 (CDT) Received: (hashcash-sendmail, from uid 1001); Mon, 5 Jun 2006 09:43:49 -0500 Date: Mon, 5 Jun 2006 09:43:49 -0500 From: "Jim C. Nasby" To: Tom Lane Cc: Antoine , pgsql-performance@postgresql.org Subject: Re: vacuuming problems continued Message-ID: <20060605144349.GQ53487@pervasive.com> References: <92d3a4950606010454y67293765o56001e8996975b45@mail.gmail.com> <12384.1149174355@sss.pgh.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <12384.1149174355@sss.pgh.pa.us> X-Operating-System: FreeBSD 6.0-RELEASE-p4 amd64 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.11 X-Hashcash: 1:20:060605:tgl@sss.pgh.pa.us::T8dj1nu738LYJLFJ:00000000000000000000 00000000000000000000000015is X-Hashcash: 1:20:060605:melser.anton@gmail.com::r6EuYaM5wh4/+hk1:000000000000000 0000000000000000000000000Exk X-Hashcash: 1:20:060605:pgsql-performance@postgresql.org::zL2A0zCTipY5i1b+:00000 0000000000000000000000006qV7 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/35 X-Sequence-Number: 19392 On Thu, Jun 01, 2006 at 11:05:55AM -0400, Tom Lane wrote: > Antoine writes: > > We just don't seem to be getting much benefit from autovacuum. Running > > a manual vacuum seems to still be doing a LOT, which suggests to me > > that I should either run a cron job and disable autovacuum, or just > > run a cron job on top of autovacuum. > > The default autovac parameters are very unaggressive --- have you > experimented with changing them? Do you have the FSM set large enough? Do any of the tables have a high 'churn rate' (a lot of updates) but are supposed to be small? In cases like that autovacuum may not be enough. -- Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461