| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net> |
| Cc: | Joe Maldonado <jmaldonado(at)webehosting(dot)biz>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: VACUUMING questions... |
| Date: | 2004-11-04 16:46:50 |
| Message-ID: | 418A5CFA.7010601@archonet.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Matthew T. O'Connor wrote:
> 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.
I'd read the question as asking if they got dealt with automatically,
without sysadmin involvement.
--
Richard Huxton
Archonet Ltd
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Patrick Hatcher | 2004-11-04 17:11:57 | how to edit a function from psql? |
| Previous Message | Matt Clark | 2004-11-04 16:46:25 | Re: Restricting Postgres |