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

From Joshua D. Drake
Subject Re: Autovacuum in the backend
Date
Msg-id 42B2752B.6090402@commandprompt.com
Whole thread Raw
In response to Re: Autovacuum in the backend  (Josh Berkus <josh@agliodbs.com>)
Responses Re: Autovacuum in the backend
List pgsql-hackers
Josh Berkus wrote:
> 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?"

Can't argue that except... RTFM ;). I am not saying it doesn't have a 
validity. I am just saying that if you actually pay attention to 
PostgreSQL and maintain it, you don't need it ;)

Sincerely,

Joshua D. Drake


> 



pgsql-hackers by date:

Previous
From: Michael Glaesemann
Date:
Subject: Re: [PATCHES] Escape handling in strings
Next
From: "Joshua D. Drake"
Date:
Subject: Re: Autovacuum in the backend