> 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 ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
