pg_autovacuum not sleeping

Поиск
Список
Период
Сортировка
От Brandon Metcalf
Тема pg_autovacuum not sleeping
Дата
Msg-id Pine.LNX.4.58L.0509201551070.1182@cash.rhiamet.com
обсуждение исходный текст
Ответы Re: pg_autovacuum not sleeping  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-general
We're using pg_autovacuum with PostgreSQL 8.0.3 and it isn't sleeping
as long as the claims it will.  For example,

  ...
  [2005-09-20 15:40:23 CDT] INFO:         last_analyze_count: 21735550; last_vacuum_count: 21735009
  [2005-09-20 15:40:23 CDT] INFO:         analyze_threshold: 40676; vacuum_threshold: 81352
  [2005-09-20 15:40:23 CDT] DEBUG:   347 All DBs checked in: 1428748500 usec, will sleep for 4886 secs.
  [2005-09-20 15:50:14 CDT] DEBUG:   Performing: VACUUM ANALYZE "public"."model_lastexport"

So, pg_autovacuum says it's going to sleep for 4886 seconds, but fires
up again after just under 600 seconds.

Can anyone explain what I'm seeing?

Thanks.

--
Brandon

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

Предыдущее
От: "Magnus Naeslund(t)"
Дата:
Сообщение: More efficient INs when comparing two columns
Следующее
От: Mike Rylander
Дата:
Сообщение: Re: Implementing a change log