Re: bug? autovacuum is not launched even if autovacuum_freeze_max_age is reached - Mailing list pgsql-hackers

From Tom Lane
Subject Re: bug? autovacuum is not launched even if autovacuum_freeze_max_age is reached
Date
Msg-id 29631.1266336037@sss.pgh.pa.us
Whole thread Raw
In response to Re: bug? autovacuum is not launched even if autovacuum_freeze_max_age is reached  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-hackers
Alvaro Herrera <alvherre@commandprompt.com> writes:
> Fujii Masao escribi�:
>> 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.

> Hmm.  Yeah, this is a serious problem.

I thought I had put in some workaround for that when I did the flat
file changes.  I don't remember what though, and it's evidently
broken now in any case.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Hitoshi Harada
Date:
Subject: Re: ToDo: plpgsql plugin for query and expression verification
Next
From: "Greg Sabino Mullane"
Date:
Subject: Re: Listen / Notify - what to do when the queue is full