Autovacuum stopped running

From: "Benjamin Krajmalnik" <kraj(at)illumen(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Autovacuum stopped running
Date: 2010-04-30 22:21:41
Message-ID: F4E6A2751A2823418A21D4A160B6898861435B@fletch.stackdump.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I had a very strange occurrence 2 days ago where autovacuum appears to
have stopped running.

I did not see any error messages in pg_log. The problem caused a file
which is usually around 50Mb but which gets updated extensively to grow
to 105GB, which in turn brought the server's performance down to
unusable levels.

Restarting Postgres got the autovacuum running again, but was just
wondering what could have cause this.

PostgreSQL 8.4.3 amd64 on FreeBSD 7.2.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message STEVE NAYAM 2010-04-30 22:51:23 regarding postgreSql Admin position
Previous Message Scott Whitney 2010-04-30 22:21:02 Re: more 10K disks or less 15K disks