VACUUM FREEZE vs plain VACUUM

From: Ron Johnson <ronljohnsonjr(at)gmail(dot)com>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: VACUUM FREEZE vs plain VACUUM
Date: 2025-07-17 22:03:20
Message-ID: CANzqJaABg-S=qYnn7P2BzVzLYc2Z3WzE27Kw3=erT2KyC+F-LA@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: 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!

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message David G. Johnston 2025-07-17 22:26:57 Re: VACUUM FREEZE vs plain VACUUM
Previous Message Holger Jakobs 2025-07-15 14:17:27 Re: pg_verifybackup