Tina Messmann <tina(dot)messmann(at)xinux(dot)de> writes:
> does this include the template1 database? So i have to vacuum the
> tempate1 database too on a regular basis to avoid the rolling over of
> the transaction id?
Only if you're in the habit of modifying template1.
If you make occasional one-time changes to template1 (like, say,
installing plpgsql in it) you can do a "vacuum freeze" afterward
to make sure all is well; then you needn't include template1 in
your list of things to vacuum regularly.
regards, tom lane