Re: recovery from xid wraparound

Поиск
Список
Период
Сортировка
От Shane Wright
Тема Re: recovery from xid wraparound
Дата
Msg-id 64F50E3BAAE32A4FA0686CF651E0D476146BCC@exchange11.ad.edigitalresearch.com
обсуждение исходный текст
Ответ на recovery from xid wraparound  ("Shane Wright" <shane.wright@edigitalresearch.com>)
Список pgsql-general
Tom,

Thanks

But are there just 28 (the 28 that have been vacuumed), or are there more (in 7.4).

Happy there's no guarantee, but would help to know any possible damager in my current situation,

Thanks

S



-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: 24 October 2006 15:23
To: Shane Wright
Cc: Martijn van Oosterhout; pgsql-general@postgresql.org
Subject: Re: [GENERAL] recovery from xid wraparound


"Shane Wright" <shane.wright@edigitalresearch.com> writes:
>> Just make sure you've really covered *all* the system tables.

> I've been under the impression system tables get done first, then
> user(me)-created tables after -

No, there's no such guarantee.  A database-wide vacuum just does the tables in the order it finds 'em in pg_class.

            regards, tom lane


В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: recovery from xid wraparound
Следующее
От: "Wes Sheldahl"
Дата:
Сообщение: Re: unstable postgres on freebsd