bug? autovacuum is not launched even if autovacuum_freeze_max_age is reached

From: Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: bug? autovacuum is not launched even if autovacuum_freeze_max_age is reached
Date: 2010-02-16 09:34:57
Message-ID: 3f0b79eb1002160134m566f71e4t7685f1a9c947e307@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

In HEAD, when autovacuum is disabled, autovacuum process is not
launched forcibly to prevent XID wraparound even if we go through
autovacuum_freeze_max_age. This seems to be because
ShmemVariableCache->xidVacLimit is not initialized (i.e.,
SetTransactionIdLimit() is not called) until VACUUM is performed.

OTOH, in older version, ShmemVariableCache->xidVacLimit is always
initialized when backend updates the flat database file, and then
autovacuum process seems to be launched forcibly as expected.

Is this bug? I guess that it derives from the changes around flag
file done a while ago.

Regards,

--
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Fujii Masao 2010-02-16 09:56:16 Re: Streaming replication on win32, still broken
Previous Message Jan Urbański 2010-02-16 09:05:47 Re: xpath improvement V2