X-Original-To: pgsql-docs-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 596859DCA0C for ; Wed, 18 Jan 2006 19:28:56 -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 64587-05 for ; Wed, 18 Jan 2006 19:28:56 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from glacier.frostconsultingllc.com (glacier.frostconsultingllc.com [64.127.99.90]) by postgresql.org (Postfix) with ESMTP id 23D719DC9A9 for ; Wed, 18 Jan 2006 19:28:49 -0400 (AST) Received: from localhost ([127.0.0.1]) by glacier.frostconsultingllc.com with esmtp (Exim 4.60) (envelope-from ) id 1EzMjT-0001Gz-GZ; Wed, 18 Jan 2006 15:28:51 -0800 Date: Wed, 18 Jan 2006 15:28:51 -0800 (PST) From: Jeff Frost To: Scott Marlowe cc: "Jim C. Nasby" , pgsql-docs@postgresql.org Subject: Re: vacuum and routine maintenance docs In-Reply-To: <1137626008.25500.90.camel@state.g2switchworks.com> Message-ID: References: <1137518049.25500.27.camel@state.g2switchworks.com> <20060117224941.GI17896@pervasive.com> <1137538769.25500.49.camel@state.g2switchworks.com> <20060118221951.GT17896@pervasive.com> <1137626008.25500.90.camel@state.g2switchworks.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-SA-Exim-Connect-IP: 127.0.0.1 X-SA-Exim-Mail-From: jeff@frostconsultingllc.com X-SA-Exim-Scanned: No (on glacier.frostconsultingllc.com); SAEximRunCond expanded to false X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.09 required=5 tests=[AWL=0.090] X-Spam-Score: 0.09 X-Spam-Level: X-Archive-Number: 200601/36 X-Sequence-Number: 3426 On Wed, 18 Jan 2006, Scott Marlowe wrote: > Well, I'm kind of tempted to rewrite the whole section. I'd like to > come up with some objectives of what we're trying to cover there, and > basically start over with all the information that's there plus the > other stuff on fsm and mvcc as it applies to vacuum, or link to it as > needed. A couple questions I find difficult to answer using the online docs are: * Is my autovacuum doing a good enough job? * What percentage of bloat is reasonable (and how can I tell what my bloat level is)? * What transaction loads would require specific autovacuum settings, or manual vacuum fulls? -- Jeff Frost, Owner Frost Consulting, LLC http://www.frostconsultingllc.com/ Phone: 650-780-7908 FAX: 650-649-1954