vacuum v. vacuumdb

От:

Erik Jones <erik@myemma.com>

Дата:

5 января 2007 г. в 17:05:55

Quick question,  when running a VACUUM query through the postmaster, 
does it use the external vacuumdb tool?

-- 
erik jones 
software development
emma(r)

Re: vacuum v. vacuumdb

От:

"Jeremy Haile" <jhaile@fastmail.fm>

Дата:

5 января 2007 г. в 17:12:25

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"  said:
> Quick question,  when running a VACUUM query through the postmaster, 
> does it use the external vacuumdb tool?
> 
> -- 
> erik jones 
> 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

Re: vacuum v. vacuumdb

От:

Gavin Hamill <gdh@laterooms.com>

Дата:

5 января 2007 г. в 17:46:04

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.