Re: Clarification Regarding Vacuum and template1 - Mailing list pgsql-general

From Ludwig Isaac Lim
Subject Re: Clarification Regarding Vacuum and template1
Date
Msg-id 20060207153256.82197.qmail@web33103.mail.mud.yahoo.com
Whole thread Raw
In response to Re: Clarification Regarding Vacuum and template1  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
>
> 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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: strange query runtime
Next
From: Bruce Momjian
Date:
Subject: Re: Sequences/defaults and pg_dump