Re: Autovacuum in the backend

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Autovacuum in the backend
Date: 2005-06-16 04:07:30
Message-ID: 200506152107.31086.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Neil Conway 2005-06-16 04:08:20 Re: Autovacuum in the backend
Previous Message Josh Berkus 2005-06-16 04:04:33 Re: Autovacuum in the backend

Browse pgsql-hackers by date

  From Date Subject
Next Message Neil Conway 2005-06-16 04:08:20 Re: Autovacuum in the backend
Previous Message Josh Berkus 2005-06-16 04:04:33 Re: Autovacuum in the backend