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

Commitda103c7

Browse files
doc: Adjust documentation for vacuumdb --missing-stats-only.
The sentence in question gave readers the impression that vacuumdbremoves statistics for a period of time while analyzing, but it'sactually meant to convey that --analyze-in-stages temporarilyreplaces existing statistics with ones generated with lowerstatistics targets.Reported-by: Frédéric Yhuel <frederic.yhuel@dalibo.com>Reviewed-by: Frédéric Yhuel <frederic.yhuel@dalibo.com>Reviewed-by: "David G. Johnston" <david.g.johnston@gmail.com>Reviewed-by: Corey Huinker <corey.huinker@gmail.com>Reviewed-by: Jeff Davis <pgsql@j-davis.com>Discussion:https://postgr.es/m/4b94ca16-7a6d-4581-b2aa-4ea79dbc082a%40dalibo.comBackpatch-through: 18
1 parent3a95481 commitda103c7

File tree

1 file changed

+5
-3
lines changed

1 file changed

+5
-3
lines changed

‎doc/src/sgml/ref/vacuumdb.sgml‎

Lines changed: 5 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -282,9 +282,11 @@ PostgreSQL documentation
282282
<listitem>
283283
<para>
284284
Only analyze relations that are missing statistics for a column, index
285-
expression, or extended statistics object. This option prevents
286-
<application>vacuumdb</application> from deleting existing statistics
287-
so that the query optimizer's choices do not become transiently worse.
285+
expression, or extended statistics object. When used with
286+
<option>--analyze-in-stages</option>, this option prevents
287+
<application>vacuumdb</application> from temporarily replacing existing
288+
statistics with ones generated with lower statistics targets, thus
289+
avoiding transiently worse query optimizer choices.
288290
</para>
289291
<para>
290292
This option can only be used in conjunction with

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp