> > Yes: the wraparound limit is for transactions > cluster-wide, not per > database. If you make 1 change in template1 and then 2 > billion > changes in some other databases, template1 is broken > unless it's > been vacuumed meanwhile. > > regards, tom lane >
So in practice, should one vacuum template1 when vacuuming other database (Assuming one doesn't use vaccumdb script when vacuuming database)? Will this problem occur if I vacuum all database except template1? Thanks for the previous quick response. Thank you once again. ludwig lim __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org
