Re: Transaction ID wraparound: problem and proposed solution

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Transaction ID wraparound: problem and proposed solution
Дата
Msg-id 788.973447357@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Transaction ID wraparound: problem and proposed solution  (Hannu Krosing <hannu@tm.ee>)
Ответы Re: Transaction ID wraparound: problem and proposed solution  (Mark Hollomon <mhh@mindspring.com>)
Список pgsql-hackers
Hannu Krosing <hannu@tm.ee> writes:
>> * disk space --- letting pg_log grow without bound isn't a pleasant
>> prospect either.

> How will 2x size increase of xid cause "boundless" growth of pg_log ;)

OK, 2^64 isn't mathematically unbounded, but let's see you buy a disk
that will hold it ;-).  My point is that if we want to think about
allowing >4G transactions, part of the answer has to be a way to recycle
pg_log space.  Otherwise it's still not really practical.
        regards, tom lane


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

Предыдущее
От: Larry Rosenman
Дата:
Сообщение: Re: Transaction ID wraparound: problem and proposed solution
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Transaction ID wraparound: problem and proposed solution