| From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
|---|---|
| To: | Josh Berkus <josh(at)agliodbs(dot)com> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Autovacuum in the backend |
| Date: | 2005-06-17 07:00:59 |
| Message-ID: | 42B2752B.6090402@commandprompt.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general 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
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joshua D. Drake | 2005-06-17 07:03:26 | Re: Autovacuum in the backend |
| Previous Message | Thomas F. O'Connell | 2005-06-17 04:55:34 | Re: Autovacuum in the backend |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joshua D. Drake | 2005-06-17 07:03:26 | Re: Autovacuum in the backend |
| Previous Message | Michael Glaesemann | 2005-06-17 05:09:50 | Re: [PATCHES] Escape handling in strings |