Joe Maldonado wrote:
Hello all,
I have a few somewhat simple questions....

Does the postmaster vacuum it's internal (pg_*) tables? if not
what is the best way to vacuum them without having to vacuum the entire db?
and how often is this recommended to be done?

No, and I'd vacuum full template1.

How often? Depends on how much activity you've got on your system tables. If you look at the output on vacuum verbose you can see how much work it has to do.
--
Richard Huxton
Archonet Ltd


---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Reply via email to