Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit27f953e

Browse files
committed
Remove outdated recommendation for manual VACUUM
We have had a working and tunable autovacuumfor at least a decade now, so remove the recommendation tomanually vacuum tables at least every night.Autovacuum is now also triggered by INSERTs, so we can alsoremove the recommendation to run VACUUM (ANALYZE) after lotsof INSERTs or DELETEs.Instead, suggest using autovacuum by moving the respectiveparagraph up to where the importance of VACUUM is emphasized.Author: Laurenz Albe <laurenz.albe@cybertec.at>Reviewed-By: Magnus Hagander, Peter GeogheganDiscussion:https://postgr.es/m/6f5e3da98fec14640f389d7b84c3b413833697f4.camel@cybertec.at
1 parentd28e26b commit27f953e

File tree

1 file changed

+5
-15
lines changed

1 file changed

+5
-15
lines changed

‎doc/src/sgml/ref/vacuum.sgml

Lines changed: 5 additions & 15 deletions
Original file line numberDiff line numberDiff line change
@@ -377,15 +377,11 @@ VACUUM [ FULL ] [ FREEZE ] [ VERBOSE ] [ ANALYZE ] [ <replaceable class="paramet
377377
</para>
378378

379379
<para>
380-
We recommend that active production databases be
381-
vacuumed frequently (at least nightly), in order to
382-
remove dead rows. After adding or deleting a large number
383-
of rows, it might be a good idea to issue a <command>VACUUM
384-
ANALYZE</command> command for the affected table. This will update the
385-
system catalogs with
386-
the results of all recent changes, and allow the
387-
<productname>PostgreSQL</productname> query planner to make better
388-
choices in planning queries.
380+
We recommend that all databases be vacuumed regularly in
381+
order to remove dead rows. <productname>PostgreSQL</productname> includes
382+
an <quote>autovacuum</quote> facility which can automate routine vacuum
383+
maintenance. For more information about automatic and manual vacuuming,
384+
see <xref linkend="routine-vacuuming"/>.
389385
</para>
390386

391387
<para>
@@ -412,12 +408,6 @@ VACUUM [ FULL ] [ FREEZE ] [ VERBOSE ] [ ANALYZE ] [ <replaceable class="paramet
412408
details.
413409
</para>
414410

415-
<para>
416-
<productname>PostgreSQL</productname> includes an <quote>autovacuum</quote>
417-
facility which can automate routine vacuum maintenance. For more
418-
information about automatic and manual vacuuming, see
419-
<xref linkend="routine-vacuuming"/>.
420-
</para>
421411
<para>
422412
Each backend running <command>VACUUM</command> without the
423413
<literal>FULL</literal> option will report its progress in the

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp