Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

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: 15 Apr 2007 06:35:58 -0700
  • Message-id: <1176644158(dot)569449(dot)270590(at)n76g2000hsh(dot)googlegroups(dot)com>

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




Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group