VACUUM FREEZE vs plain VACUUM - Mailing list pgsql-admin

From Ron Johnson
Subject VACUUM FREEZE vs plain VACUUM
Date
Msg-id CANzqJaABg-S=qYnn7P2BzVzLYc2Z3WzE27Kw3=erT2KyC+F-LA@mail.gmail.com
Whole thread Raw
Responses Re: VACUUM FREEZE vs plain VACUUM
Re: VACUUM FREEZE vs plain VACUUM
Re: VACUUM FREEZE vs plain VACUUM
List pgsql-admin
PG 14.18

For a given table, after VACUUM FREEZE, age(relfrozenxid) == 0, while after plain VACUUM, the age(relfrozenxid) == 50000000 (the system's vacuum_freeze_min_age).

Fifteen minutes later, that table's age(relfrozenxid) has increased.  Eventually, it will hit autovacuum_freeze_max_age and autovacuum will do its thing.

Does VACUUM FREEZE do something extra or special than to defer autovacuum for an extra 50,000,000 transactions?

--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

pgsql-admin by date:

Previous
From: Holger Jakobs
Date:
Subject: Re: pg_verifybackup
Next
From: "David G. Johnston"
Date:
Subject: Re: VACUUM FREEZE vs plain VACUUM