autovacuum vacuums entire database...is this right?

From: "richyen3(at)gmail(dot)com" <richyen3(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: autovacuum vacuums entire database...is this right?
Date: 2007-04-15 13:35:58
Message-ID: 1176644158.569449.270590@n76g2000hsh.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I'm just wondering if autovacuum is ever supposed to vacuum the entire
database during one of its runs. As far as I remember, it's supposed
to vacuum one table at a time, based on the
autovacuum_vacuum_threshold, autovacuum_analyze_threshold, etc.
settings.

For some reason, autovacuum decided to run a vacuum on my entire
database (29GB large), and it's taking forever:

select now(), query_start, current_query, backend_start, procpid,
usename from pg_stat_activity where current_query <> '<IDLE>';
now | query_start |
current_query | backend_start | procpid | usename
-------------------------------+-------------------------------
+---------------+-------------------------------+---------+----------
2007-04-15 06:34:27.925042-07 | 2007-04-14 22:23:31.283894-07 |
VACUUM | 2007-04-14 22:23:31.274121-07 | 9406 | postgres

Is this expected behavior?

--Richard

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Angelo 2007-04-15 13:39:28 Re: Dumping part (not all) of the data in a database...methods?
Previous Message Alain Roger 2007-04-15 07:33:12 issue when export/import table including pictures