From: | "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net> |
---|---|
To: | Richard Huxton <dev(at)archonet(dot)com> |
Cc: | Joe Maldonado <jmaldonado(at)webehosting(dot)biz>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: VACUUMING questions... |
Date: | 2004-11-04 15:48:04 |
Message-ID: | 418A4F34.7030805@zeut.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Richard Huxton wrote:
> 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.
I'm not sure what you mean by No. If I fun a vacuum command from psql
inside one of my databases, then all the pg_ tables will get vacuumed.
Also, vacuum full on template1 is only going to help with the small
handful of shared tables. Most of the pg_ tables are not shared, so
vacuuming them inside template1 is not going to help the their
performance inside a particular DB.
>
> 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.
You can also run pg_autovacuum which does monitor activity for you and
does vacuum system tables.
From | Date | Subject | |
---|---|---|---|
Next Message | Kevin Barnard | 2004-11-04 16:00:38 | Re: [PERFORM] Restricting Postgres |
Previous Message | Tom Lane | 2004-11-04 15:25:10 | Re: Selecting a random row |