Search Postgresql Archives

Re: Clarification Regarding Vacuum and template1

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



> 
> 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 


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux