Agressive vacuum meaning
От | Arseny Sher |
---|---|
Тема | Agressive vacuum meaning |
Дата | |
Msg-id | 87lgaoiwwn.fsf@ars-thinkpad обсуждение исходный текст |
Список | pgsql-docs |
Hello, I am a bit confused by the following. Apparently what is meant by 'aggressive vacuuming' at [1] and 'aggressive freezing' [2] is not entirely the same: the latter not only visites all the pages, it also freezes all visible tuples (vacuum_freeze_min_age = 0). You might say that *vacuuming* is not *freezing*, so it is fine that these terms differ, but it looks like that aggressiveness of vacuum refers only to freezing, because if there are any dead tuples on page we visit it anyway -- which makes it even more confusing. Perhaps things can be improved here, e.g. coin 'agressive freezing' everywhere and explicitly say in FREEZE docs that it additionaly ignores vacuum_freeze_min_age? Or I just misunderstand something. [1] https://www.postgresql.org/docs/devel/static/routine-vacuuming.html [2] https://www.postgresql.org/docs/devel/static/sql-vacuum.html -- Arseny Sher Postgres Professional: http://www.postgrespro.com The Russian Postgres Company
В списке pgsql-docs по дате отправления: