| From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
|---|---|
| To: | Michael Goldner <MGoldner(at)agmednet(dot)com> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Is it normal for Autovacuum running continuously? |
| Date: | 2007-02-13 16:27:49 |
| Message-ID: | 20070213162749.GC11987@alvh.no-ip.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Michael Goldner wrote:
> I notice in my postgres logfile that autovacuum is running every minute.
> The server had no overnight activity, yet this has been going on for days.
> Overall performance of the database seems to be slow, and I assume that it
> is related.
It is normal. I doubt your performance problem is related to
autovacuum. When you say "overall performance seems to be slow", it
means you haven't actually measured individual queries and found that
they are actually slow, no?
> I'm running 8.1.4 on Redhat EL4.3.
>
> Is this normal for autovacuum?
Yes.
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
| From | Date | Subject | |
|---|---|---|---|
| Next Message | gpio Oxxce | 2007-02-13 17:19:27 | possible Bug in windows version ? |
| Previous Message | Matthew T. O'Connor | 2007-02-13 16:08:24 | Re: Is it normal for Autovacuum running continuously? |