Re: Clarification Regarding Vacuum and template1

From: Ludwig Isaac Lim <ludz_lim(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Clarification Regarding Vacuum and template1
Date: 2006-02-07 15:32:56
Message-ID: 20060207153256.82197.qmail@web33103.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2006-02-07 15:34:22 Re: Sequences/defaults and pg_dump
Previous Message Tom Lane 2006-02-07 15:26:42 Re: strange query runtime