Re: WAL-based allocation of XIDs is insecure

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: WAL-based allocation of XIDs is insecure
Дата
Msg-id 20587.983824177@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: WAL-based allocation of XIDs is insecure  (Ian Lance Taylor <ian@airs.com>)
Список pgsql-hackers
Ian Lance Taylor <ian@airs.com> writes:
> Tom Lane <tgl@sss.pgh.pa.us> writes:
>> Up through 7.0, Postgres allocated XIDs a thousand at a time, and not
>> only did the not-yet-used XIDs get lost in a crash, they'd get lost in
>> a normal shutdown too.  What I propose will waste XIDs in a crash but
>> not in a normal shutdown, so it's still an improvement over prior
>> versions as far as XID consumption goes.

> I find this somewhat troubling, since I like to think in terms of
> long-running systems--like, decades.  But I guess it's OK (for me) if
> it is fixed in the next couple of years.

Agreed, we need to do something about the XID-wrap problem pretty soon.
But we're not solving it for 7.1, and in the meantime I don't think
these changes make much difference either way.
        regards, tom lane


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

Предыдущее
От: Ian Lance Taylor
Дата:
Сообщение: Re: WAL-based allocation of XIDs is insecure
Следующее
От: Peter Eisentraut
Дата:
Сообщение: pg_restore -U