Обсуждение: vacuum v. vacuumdb

Поиск
Список
Период
Сортировка

vacuum v. vacuumdb

От
Erik Jones
Дата:
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)


Re: vacuum v. vacuumdb

От
"Jeremy Haile"
Дата:
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

Re: vacuum v. vacuumdb

От
Gavin Hamill
Дата:
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.