Обсуждение: 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. 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.