Hi
Like the docs say, vacuumdb is a "wrapper around the SQL command VACUUM"
which I used to use in dim-and-distant pre-autovacuum days came for cronjobs,
but until messing around with pg_upgrade recently I hadn't really had much
use for it. Anyway, the docs also say "There is no effective difference
between vacuuming and analyzing databases via this utility and via other
methods for accessing the server", which IMHO seems a bit out-of-date as
it now does two things which you can't do directly via e.g. psql:
- generate statistics in stages (9.4)
- parallel vacuum (9.5)
Attached patches (for 9.4 and 9.5/HEAD) update the description to make
clear that it now does a bit more than just execute a single command.
Regards
Ian Barwick
--
Ian Barwick http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
diff --git a/doc/src/sgml/ref/vacuumdb.sgml b/doc/src/sgml/ref/vacuumdb.sgml
new file mode 100644
index 3ecd999..35e3d6f
*** a/doc/src/sgml/ref/vacuumdb.sgml
--- b/doc/src/sgml/ref/vacuumdb.sgml
*************** PostgreSQL documentation
*** 65,71 ****
command <xref linkend="SQL-VACUUM">.
There is no effective difference between vacuuming and analyzing
databases via this utility and via other methods for accessing the
! server.
</para>
</refsect1>
--- 65,73 ----
command <xref linkend="SQL-VACUUM">.
There is no effective difference between vacuuming and analyzing
databases via this utility and via other methods for accessing the
! server. However it does provide additional functionality for generating
! statistics in stages, which is useful when optimizing a newly populated
! database.
</para>
</refsect1>
diff --git a/doc/src/sgml/ref/vacuumdb.sgml b/doc/src/sgml/ref/vacuumdb.sgml
new file mode 100644
index 92b8984..d640887
*** a/doc/src/sgml/ref/vacuumdb.sgml
--- b/doc/src/sgml/ref/vacuumdb.sgml
*************** PostgreSQL documentation
*** 65,71 ****
command <xref linkend="SQL-VACUUM">.
There is no effective difference between vacuuming and analyzing
databases via this utility and via other methods for accessing the
! server.
</para>
</refsect1>
--- 65,73 ----
command <xref linkend="SQL-VACUUM">.
There is no effective difference between vacuuming and analyzing
databases via this utility and via other methods for accessing the
! server. However it does provide additional functionality for generating
! statistics in stages, which is useful when optimizing a newly populated
! database, and for executing vacuum or analyze commands in parallel.
</para>
</refsect1>
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
