Hi :
Saw this post on BUGS mailing list : "Olleg Samoylov" <olleg_s ( at ) mail ( dot ) ru> writes: >> Opps, template1 must not be vacuumed. >Says who? >If we didn't vacuum template1 then it would be subject to >XID wraparound >problems, unless it had never been modified, which is >something vacuumdb >can't count on. > regards, tom lane Under normal circumstances, there's no need to vacuum template1 right? Its quite difficult to imagine XID wraparound problems occuring in template1. I can't think how can 4 billion transactions occur in template1 if template1 is just used as a template in creating a new database. Am I missing something here? Thank you very much, ludwig lim __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
