diff options
| author | Peter Eisentraut <peter_e@gmx.net> | 2014-04-14 23:15:05 -0400 |
|---|---|---|
| committer | Peter Eisentraut <peter_e@gmx.net> | 2014-04-15 00:44:25 -0400 |
| commit | c92c3d50d7fbe7391b5fc864b444346b2db29ffe (patch) | |
| tree | f013c8c717ca03f1a69d34e206c22f7c7cdf22f0 /doc/src | |
| parent | 0d3b2b80aa6aee753f372bb0300a131691e9f55c (diff) | |
| download | postgresql-c92c3d50d7fbe7391b5fc864b444346b2db29ffe.tar.gz postgresql-c92c3d50d7fbe7391b5fc864b444346b2db29ffe.zip | |
vacuumdb: Add option --analyze-in-stages
Add vacuumdb option --analyze-in-stages which runs ANALYZE three times
with different configuration settings, adopting the logic from the
analyze_new_cluster.sh script that pg_upgrade generates. That way,
users of pg_dump/pg_restore can also use that functionality.
Change pg_upgrade to create the script so that it calls vacuumdb instead
of implementing the logic itself.
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/ref/vacuumdb.sgml | 20 |
1 files changed, 20 insertions, 0 deletions
diff --git a/doc/src/sgml/ref/vacuumdb.sgml b/doc/src/sgml/ref/vacuumdb.sgml index 1c519f5944f..3ecd9999812 100644 --- a/doc/src/sgml/ref/vacuumdb.sgml +++ b/doc/src/sgml/ref/vacuumdb.sgml @@ -204,6 +204,26 @@ PostgreSQL documentation </varlistentry> <varlistentry> + <term><option>--analyze-in-stages</option></term> + <listitem> + <para> + Only calculate statistics for use by the optimizer (no vacuum), + like <option>--analyze-only</option>. Run several (currently three) + stages of analyze with different configuration settings, to produce + usable statistics faster. + </para> + + <para> + This option is useful to analyze a database that was newly populated + from a restored dump or by <command>pg_upgrade</command>. This option + will try to create some statistics as fast as possible, to make the + database usable, and then produce full statistics in the subsequent + stages. + </para> + </listitem> + </varlistentry> + + <varlistentry> <term><option>-?</></term> <term><option>--help</></term> <listitem> |