VACUUM FREEZE vs plain VACUUM
| От | Ron Johnson |
|---|---|
| Тема | VACUUM FREEZE vs plain VACUUM |
| Дата | |
| Msg-id | CANzqJaABg-S=qYnn7P2BzVzLYc2Z3WzE27Kw3=erT2KyC+F-LA@mail.gmail.com обсуждение исходный текст |
| Ответы |
Re: VACUUM FREEZE vs plain VACUUM
Re: VACUUM FREEZE vs plain VACUUM Re: VACUUM FREEZE vs plain VACUUM |
| Список | 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 по дате отправления: