Re: VACUUMING questions... - Mailing list pgsql-general

From Richard Huxton
Subject Re: VACUUMING questions...
Date
Msg-id 418A3BB6.9030801@archonet.com
Whole thread Raw
In response to VACUUMING questions...  (Joe Maldonado <jmaldonado@webehosting.biz>)
Responses Re: VACUUMING questions...
List pgsql-general
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

pgsql-general by date:

Previous
From: Joe Maldonado
Date:
Subject: VACUUMING questions...
Next
From: Csaba Nagy
Date:
Subject: Re: Selecting a random row