X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 915799DCA88 for ; Mon, 6 Feb 2006 19:04:05 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 68934-03 for ; Mon, 6 Feb 2006 19:04:07 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from floppy.pyrenet.fr (floppy.pyrenet.fr [194.116.145.2]) by postgresql.org (Postfix) with ESMTP id 4D6E89DCA5F for ; Mon, 6 Feb 2006 19:04:02 -0400 (AST) Received: by floppy.pyrenet.fr (Postfix, from userid 106) id 8DF1430941; Tue, 7 Feb 2006 00:04:03 +0100 (MET) From: Chris Browne X-Newsgroups: pgsql.performance Subject: Re: Default autovacuum settings too conservative Date: Mon, 06 Feb 2006 17:15:16 -0500 Organization: cbbrowne Computing Inc Lines: 17 Message-ID: <60mzh4i16z.fsf@dba2.int.libertyrms.com> References: <20060201211633.GM95850@pervasive.com> <43E12A03.6070906@zeut.net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Complaints-To: usenet@news.hub.org User-Agent: Gnus/5.1007 (Gnus v5.10.7) XEmacs/21.4.18 (linux) Cancel-Lock: sha1:3jcA2GgJFQDN/FndsiU/OKZGg5A= To: pgsql-performance@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.242 required=5 tests=[AWL=0.242] X-Spam-Score: 0.242 X-Spam-Level: X-Archive-Number: 200602/49 X-Sequence-Number: 17035 matthew@zeut.net ("Matthew T. O'Connor") writes: > I think the default settings should be designed to minimize the > impact autovacuum has on the system while preventing the system from > ever getting wildly bloated (also protect xid wraparound, but that > doesn't have anything to do with the thresholds). That would suggest setting the "base threshold" autovacuum_vacuum_threshold relatively low, and the "scale factor" autovacuum_vacuum_scale_factor fairly high. -- let name="cbbrowne" and tld="ntlug.org" in name ^ "@" ^ tld;; http://cbbrowne.com/info/nonrdbms.html I think it may be possible to simplify and condense the content of this thread somewhat: "GX is an ex-API. It is no longer supported" - The Rest of Us "No it isn't. It's just pining for the fjords!" - Lawson -- Michael Paquette