pg.ddx.io pgsql-hackers@postgresql.org mailing list archive
help / color / mirror / Atom feedDescription tweak for vacuumdb
2+ messages / 2 participants
[nested] [flat]
* Description tweak for vacuumdb
@ 2016-01-04 02:05 Ian Barwick <ian@2ndquadrant.com>
0 siblings, 1 reply; 2+ messages in thread
From: Ian Barwick @ 2016-01-04 02:05 UTC (permalink / raw)
To: pgsql-hackers; pgsql-docs@postgresql.org
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
--
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs
Attachments: download all (2 files, .tar.gz)
doc-vacuumdb-94.patch (text/x-patch, 875B) download
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>
doc-vacuumdb-head.patch (text/x-patch, 933B) download
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>
* Re: Description tweak for vacuumdb
@ 2016-01-06 17:38 Robert Haas <robertmhaas@gmail.com>
parent: Ian Barwick <ian@2ndquadrant.com>
0 siblings, 0 replies; 2+ messages in thread
From: Robert Haas @ 2016-01-06 17:38 UTC (permalink / raw)
To: Ian Barwick <ian@2ndquadrant.com>; +Cc: pgsql-hackers; pgsql-docs <pgsql-docs@postgresql.org>
On Sun, Jan 3, 2016 at 9:05 PM, Ian Barwick <ian@2ndquadrant.com> wrote:
> 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.
So I think this is a good change, but...
+ 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.
...it's not entirely clear to which portion of the sentence the clause
at the end applies. Is executing vacuum or analyze commands in
parallel another case in which generating statistics in stages is
helpful, or is it another thing altogether that vacuumdb does? I know
the answer, and anyone who is reasonably clueful will too, but it
seems to me that we could probably tweak the phrasing here so that a
non-clueful person wouldn't go astray.
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
--
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2016-01-06 17:38 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2016-01-04 02:05 Description tweak for vacuumdb Ian Barwick <ian@2ndquadrant.com>
2016-01-06 17:38 ` Robert Haas <robertmhaas@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox