Clarification Regarding Vacuum and template1
От | Ludwig Isaac Lim |
---|---|
Тема | Clarification Regarding Vacuum and template1 |
Дата | |
Msg-id | 20060207150523.3386.qmail@web33112.mail.mud.yahoo.com обсуждение исходный текст |
Ответы |
Re: Clarification Regarding Vacuum and template1
|
Список | pgsql-general |
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
В списке pgsql-general по дате отправления: