Thread: Agressive vacuum meaning

Agressive vacuum meaning

From
Arseny Sher
Date:
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