Re: Clarification Regarding Vacuum and template1 - Mailing list pgsql-general

From Christopher Browne
Subject Re: Clarification Regarding Vacuum and template1
Date
Msg-id m31wye4t4v.fsf@mobile.int.cbbrowne.com
Whole thread Raw
In response to Re: Clarification Regarding Vacuum and template1  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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

pgsql-general by date:

Previous
From: Michael Glaesemann
Date:
Subject: Re: UNION or OR / INTERSECT or AND ?
Next
From: Luki Rustianto
Date:
Subject: Is there a way to limit CPU usage per user