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 70BC79DCA1E for ; Wed, 18 Jan 2006 18:48:55 -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 26763-06 for ; Wed, 18 Jan 2006 18:48:57 -0400 (AST) 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 2C7EB9DC9F7 for ; Wed, 18 Jan 2006 18:48:53 -0400 (AST) Received: by noel.decibel.org (Postfix, from userid 1001) id 0C75339820; Wed, 18 Jan 2006 16:48:56 -0600 (CST) Date: Wed, 18 Jan 2006 16:48:56 -0600 From: "Jim C. Nasby" To: Michael Riess Cc: pgsql-performance@postgresql.org Subject: Re: Autovacuum / full vacuum Message-ID: <20060118224856.GX17896@pervasive.com> References: <43CCC711.504@familyhealth.com.au> <20060117222812.GG17896@pervasive.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: X-Operating-System: FreeBSD 6.0-RELEASE amd64 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.11 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.095 required=5 tests=[AWL=0.095] X-Spam-Score: 0.095 X-Spam-Level: X-Archive-Number: 200601/315 X-Sequence-Number: 16793 On Wed, Jan 18, 2006 at 03:09:42PM +0100, Michael Riess wrote: > >There's a number of sites that have lots of info on postgresql.conf > >tuning. Google for 'postgresql.conf tuning' or 'annotated > >postgresql.conf'. > > I know some of these sites, but who should I know if the information on > those pages is correct? The information on those pages should be > published as part of the postgres documentation. Doesn't have to be too > much, maybe like this page: > > http://www.powerpostgresql.com/Downloads/annotated_conf_80.html > > But it should be part of the documentation to show newbies that not only > the information is correct, but also approved of and recommended by the > postgres team. Actually, most of what you find there is probably also found in techdocs. But of course it would be better if the docs did a better job of explaining things... -- 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