Re: Autovacuum / full vacuum - Mailing list pgsql-performance

From Andrew Sullivan
Subject Re: Autovacuum / full vacuum
Date
Msg-id 20060117171656.GL21092@phlogiston.dyndns.org
Whole thread Raw
In response to Re: Autovacuum / full vacuum  (Scott Marlowe <smarlowe@g2switchworks.com>)
Responses Re: Autovacuum / full vacuum
List pgsql-performance
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).

A


--
Andrew Sullivan  | ajs@crankycanuck.ca
This work was visionary and imaginative, and goes to show that visionary
and imaginative work need not end up well.
        --Dennis Ritchie

pgsql-performance by date:

Previous
From: Robert Treat
Date:
Subject: sum of left join greater than its parts
Next
From: Markus Schaber
Date:
Subject: Re: Autovacuum / full vacuum