Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 882F3650258 for ; Tue, 26 Aug 2008 13:22:03 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 41549-01 for ; Tue, 26 Aug 2008 13:21:48 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from lists.commandprompt.com (host-159.commandprompt.net [207.173.203.159]) by postgresql.org (Postfix) with ESMTP id 6145565022E for ; Tue, 26 Aug 2008 13:21:48 -0300 (ADT) Received: from commandprompt.com (CPE001b63afe888-CM001adea9c5a6.cpe.net.cable.rogers.com [99.236.211.160]) (authenticated bits=0) by lists.commandprompt.com (8.13.8/8.13.8) with ESMTP id m7QGOnfx003052 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO) for ; Tue, 26 Aug 2008 09:24:52 -0700 Date: Tue, 26 Aug 2008 12:21:44 -0400 From: Andrew Sullivan To: pgsql-performance@postgresql.org Subject: Re: Autovacuum does not stay turned off Message-ID: <20080826162144.GX10936@commandprompt.com> Mail-Followup-To: Andrew Sullivan , pgsql-performance@postgresql.org References: <48B420F4.5020406@absolute-performance.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <48B420F4.5020406@absolute-performance.com> User-Agent: Mutt/1.5.17 (2007-11-01) X-Greylist: Sender succeeded SMTP AUTH, not delayed by milter-greylist-4.0 (lists.commandprompt.com [207.173.203.159]); Tue, 26 Aug 2008 09:24:53 -0700 (PDT) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200808/329 X-Sequence-Number: 31210 On Tue, Aug 26, 2008 at 09:27:48AM -0600, Jerry Champlin wrote: > > Does anyone know what will cause this bahavior for autovacuum? You're probably approaching the wraparound limit in some database. If you think you can't afford the overhead when users are accessing the system, when are you vacuuming? A -- Andrew Sullivan ajs@commandprompt.com +1 503 667 4564 x104 http://www.commandprompt.com/