Re: Clarification Regarding Vacuum and template1

From: Christopher Browne <cbbrowne(at)acm(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Clarification Regarding Vacuum and template1
Date: 2006-02-08 00:00:00
Message-ID: m31wye4t4v.fsf@mobile.int.cbbrowne.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> So in practice, should one vacuum template1 when
> vacuuming other database (Assuming one doesn't use vaccumdb
> script when vacuuming database)?

In practice, it shouldn't be a big deal to vacuum template1 once in a
while, because, since it shouldn't have much data other than
pg_catalog tables in it, it shouldn't take long to vacuum it.

If you vacuum it once a day or once a week or such, the 15 seconds
won't take much out of the life of the disk drives...
--
let name="cbbrowne" and tld="gmail.com" in name ^ "@" ^ tld;;
http://linuxdatabases.info/info/postgresql.html
This login session: $13.99

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Dick Kniep 2006-02-08 00:07:21 Re: B-tree performance improvements in 8.x
Previous Message Michael Glaesemann 2006-02-07 22:54:10 Re: UNION or OR / INTERSECT or AND ?