Re: Autovacuum in the backend - Mailing list pgsql-hackers

From Rod Taylor
Subject Re: Autovacuum in the backend
Date
Msg-id 1118898857.78366.106.camel@home
Whole thread Raw
In response to Re: Autovacuum in the backend  ("Matthew T. O'Connor" <matthew@zeut.net>)
List pgsql-hackers
On Thu, 2005-06-16 at 00:44 -0400, Matthew T. O'Connor wrote:
> Joshua D. Drake wrote:
> 
> > Just my own two cents. First I am not knocking the work that has been 
> > on autovacuum. I am sure that it was a leap on its own to get it to 
> > work. However I will say that I just don't see the reason for it.
> 
> * Eliminates newbie confusion

Ignore everything else. This one is the clincher.

Someone doing serious database work is going to read the docs to find
out about backup / restore processes and basic tuning. They'll run
across the disable switch for autovacuum soon enough.

The jack of all trades IT guy who is running some minor work but doesn't
know much about databases in general won't have as many hurdles to
climb.


Besides, vacuum off by default possibly makes for huge files and takes
forever to reclaim space (cluster, vacuum full, etc.). Vacuum on by
default means worst case they turn it off and instantly their IO load
decreases.
-- 



pgsql-hackers by date:

Previous
From: Greg Stark
Date:
Subject: Re: [GENERAL] INHERITS and planning
Next
From: Tom Lane
Date:
Subject: Re: Autovacuum in the backend