Agressive vacuum meaning - Mailing list pgsql-docs

From Arseny Sher
Subject Agressive vacuum meaning
Date
Msg-id 87lgaoiwwn.fsf@ars-thinkpad
Whole thread Raw
List 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 by date:

Previous
From: PG Doc comments form
Date:
Subject: Building client-only fails
Next
From: Peter Eisentraut
Date:
Subject: Re: \i and \ir separated by \if now...