> 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
