VACUUM FREEZE vs plain VACUUM

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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!

[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux