pgsql: Remove outdated recommendation for manual VACUUM

From: Magnus Hagander <magnus(at)hagander(dot)net>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Remove outdated recommendation for manual VACUUM
Date: 2022-06-27 17:48:41
Message-ID: E1o5sql-0003OT-J3@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Remove outdated recommendation for manual VACUUM

We have had a working and tunable autovacuum
for at least a decade now, so remove the recommendation to
manually vacuum tables at least every night.
Autovacuum is now also triggered by INSERTs, so we can also
remove the recommendation to run VACUUM (ANALYZE) after lots
of INSERTs or DELETEs.

Instead, suggest using autovacuum by moving the respective
paragraph up to where the importance of VACUUM is emphasized.

Author: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
Reviewed-By: Magnus Hagander, Peter Geoghegan
Discussion: https://postgr.es/m/6f5e3da98fec14640f389d7b84c3b413833697f4.camel@cybertec.at

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/27f953ea9901c08fb3e4064f9a31e07bc30c1e6d

Modified Files
--------------
doc/src/sgml/ref/vacuum.sgml | 20 +++++---------------
1 file changed, 5 insertions(+), 15 deletions(-)

Responses

Browse pgsql-committers by date

  From Date Subject
Next Message Bruce Momjian 2022-06-27 18:57:34 Re: pgsql: Remove outdated recommendation for manual VACUUM
Previous Message Peter Eisentraut 2022-06-27 10:54:48 pgsql: PL/Python: Update guide to alternative expected files