From: Scott Marlowe <smarlowe@g2switchworks.com>
To: Andrew Sullivan <ajs@crankycanuck.ca>
Cc: pgsql-performance@postgresql.org
Subject: Re: Autovacuum / full vacuum
Date: Tue, 17 Jan 2006 11:31:43 -0600
Message-ID: <1137519102.25500.36.camel@state.g2switchworks.com> (raw)
In-Reply-To: <20060117171656.GL21092@phlogiston.dyndns.org>
References: <dqigaf$1b98$1@news.hub.org>
<43CCC711.504@familyhealth.com.au>
<dqih4p$1clg$1@news.hub.org>
<m3zmlvq7c9.fsf@mobile.int.cbbrowne.com>
<dqj07o$2tl4$1@news.hub.org>
<20060117150800.GF21092@phlogiston.dyndns.org>
<1137513565.25500.4.camel@state.g2switchworks.com>
<20060117171656.GL21092@phlogiston.dyndns.org>
On Tue, 2006-01-17 at 11:16, Andrew Sullivan wrote:
> On Tue, Jan 17, 2006 at 09:59:25AM -0600, Scott Marlowe wrote:
> > I have to admit, looking at the documentation, that we really don't
> > explain this all that well in the administration section, and I can see
> > how easily led astray beginners are.
>
> I understand what you mean, but I suppose my reaction would be that
> what we really need is a place to keep these things, with a note in
> the docs that the "best practice" settings for these are documented
> at <some url>, and evolve over time as people gain expertise with the
> new features.
>
> I suspect, for instance, that nobody knows exactly the right settings
> for any generic workload yet under 8.1 (although probably people know
> them well enough for particular workloads).
But the problem is bigger than that. The administrative docs were
obviously evolved over time, and now they kind of jump around and around
covering the same subject from different angles and at different
depths. Even I find it hard to find what I need, and I know PostgreSQL
administration well enough to be pretty darned good at it.
For the beginner, it must seem much more confusing. The more I look at
the administration section of the docs, the more I want to reorganize
the whole thing, and rewrite large sections of it as well.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: smarlowe@g2switchworks.com, ajs@crankycanuck.ca
Subject: Re: Autovacuum / full vacuum
In-Reply-To: <1137519102.25500.36.camel@state.g2switchworks.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox