From: Arseny Sher <a.sher@postgrespro.ru>
To: pgsql-docs\@postgresql.org <pgsql-docs@postgresql.org>
Subject: Agressive vacuum meaning
Date: Fri, 06 Jul 2018 11:35:52 +0300
Message-ID: <87lgaoiwwn.fsf@ars-thinkpad> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: a.sher@postgrespro.ru
Subject: Re: Agressive vacuum meaning
In-Reply-To: <87lgaoiwwn.fsf@ars-thinkpad>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox