Thread: Agressive vacuum meaning
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