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

From Josh Berkus
Subject Re: Autovacuum in the backend
Date
Msg-id 200506152107.31086.josh@agliodbs.com
Whole thread Raw
In response to Re: Autovacuum in the backend  ("Joshua D. Drake" <jd@commandprompt.com>)
Responses Re: Autovacuum in the backend
Re: Autovacuum in the backend
Re: Autovacuum in the backend
List pgsql-hackers
Josh,

> 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.

I've personally seen at least a dozen user requests for "autovacuum in the 
backend", and had this conversation about 1,100 times:

NB: "After a week, my database got really slow."
Me: "How often are you running VACUUM ANALYZE?"
NB: "Running what?"

-- 
Josh Berkus
Aglio Database Solutions
San Francisco


pgsql-hackers by date:

Previous
From: Josh Berkus
Date:
Subject: Re: Autovacuum in the backend
Next
From: Neil Conway
Date:
Subject: Re: Autovacuum in the backend