Re: [ADMIN] Vacuum process. - Mailing list pgsql-admin

From Peter Eisentraut
Subject Re: [ADMIN] Vacuum process.
Date
Msg-id Pine.LNX.4.21.0001120418300.3735-100000@localhost.localdomain
Whole thread Raw
In response to Vacuum process.  ("Christopher L. Davis" <cld@prin.edu>)
List pgsql-admin
There shouldn't be any need to vacuum the template database. It's vacuumed
at the end of initdb and one usually doesn't make any great changes to it
afterwards.

On 2000-01-12, Christopher L. Davis mentioned:

> Sorry if this is very basic, but I have searched through the archives and
> saw mention in a message that vacuuming template1 caused problems.  So I
> just wanted to be sure.  Is it necessary to vacuum the template1 database?
> I am writing a script to backup and then vacuum my database, but wondered
> if I should include a command for vacuuming template1 in addition.  I am
> running version 6.4.  And should the recommendation change for the current
> version?
>
> Thanks,
> Chris
>
> ------------------------------------------------------------
> Christopher L. Davis       Systems and Network Administrator
> The Principia                   PHONE:  (314)-434-2100
> 13201 Clayton Road                FAX:  (314)-275-3538
> St. Louis, MO  63131         INTERNET:  cld@prin.edu
>
> ************
>
>

--
Peter Eisentraut                  Sernanders väg 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden



pgsql-admin by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: [ADMIN] bugs?
Next
From: Peter Eisentraut
Date:
Subject: Re: [ADMIN] postgresql configuration nits