Agressive vacuum meaning

From: Arseny Sher <a(dot)sher(at)postgrespro(dot)ru>
To: "pgsql-docs\(at)postgresql(dot)org" <pgsql-docs(at)postgresql(dot)org>
Subject: Agressive vacuum meaning
Date: 2018-07-06 08:35:52
Message-ID: 87lgaoiwwn.fsf@ars-thinkpad
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-docs by date

  From Date Subject
Next Message Peter Eisentraut 2018-07-07 08:44:16 Re: \i and \ir separated by \if now...
Previous Message PG Doc comments form 2018-07-04 08:28:18 Building client-only fails