vacuum v. vacuumdb
Quick question, when running a VACUUM query through the postmaster,
does it use the external vacuumdb tool?
--
erik jones <erik@myemma.com>
software development
emma(r)
Nope - the other way around. The vacuumdb tool simply executes the
VACUUM command through postmaster.
Show quoted text
On Fri, 05 Jan 2007 15:05:44 -0600, "Erik Jones" <erik@myemma.com> said:
Quick question, when running a VACUUM query through the postmaster,
does it use the external vacuumdb tool?--
erik jones <erik@myemma.com>
software development
emma(r)---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly
On Friday 05 January 2007 21:05, Erik Jones wrote:
Quick question, when running a VACUUM query through the postmaster,
does it use the external vacuumdb tool?
No, quite the opposite; the 'vacuumdb' simply invokes the VACUUM command in
the postmaster. vacuumdb along with reindexdb, createdb, createuser etc. are
simply commandline conveniences for common administrative tasks :)
Cheers,
Gavin.