Re: bug? autovacuum is not launched even if autovacuum_freeze_max_age is reached

Alvaro Herrera <alvherre(at)commandprompt(dot)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