Re: Clarification Regarding Vacuum and template1

Поиск
Список
Период
Сортировка
От Ludwig Isaac Lim
Тема Re: Clarification Regarding Vacuum and template1
Дата
Msg-id 20060207153256.82197.qmail@web33103.mail.mud.yahoo.com
обсуждение исходный текст
Ответ на Re: Clarification Regarding Vacuum and template1  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: strange query runtime
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Sequences/defaults and pg_dump