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
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 |