autovacuum vacuums entire database...is this right?

Поиск
Список
Период
Сортировка
От richyen3@gmail.com
Тема autovacuum vacuums entire database...is this right?
Дата
Msg-id 1176644158.569449.270590@n76g2000hsh.googlegroups.com
обсуждение исходный текст
Ответы Re: autovacuum vacuums entire database...is this right?
Список 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


В списке pgsql-general по дате отправления:

Предыдущее
От: "Sergei Shelukhin"
Дата:
Сообщение: one more performance question I cannot test yet :(
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: one more performance question I cannot test yet :(