Re: 64 bit XID / Wraparound / Streaming Replication

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: 64 bit XID / Wraparound / Streaming Replication
Дата
Msg-id 24303.1336397984@sss.pgh.pa.us
обсуждение исходный текст
Ответ на 64 bit XID / Wraparound / Streaming Replication  (Frank Foerster <frankwordsten@googlemail.com>)
Список pgsql-novice
Frank Foerster <frankwordsten@googlemail.com> writes:
> My question is: do other users experience the same problem and what is
> their preferred way of dealing with it ?  Also, i am aware of a discussion
> a few years ago that dealt with the usage of 64bit XIDs, but led nowhere.
> Are there any more recent plans or discussions concerning 64bit XIDs ?

I don't believe anybody is actively thinking about 64-bit XIDs at
present; the additional row storage overhead is unpleasant to
contemplate.  I'd suggest looking at whether you couldn't reduce your
rate of consumption of XIDs, for instance by merging updates into a
single transaction when possible.

            regards, tom lane

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

Предыдущее
От: Frank Foerster
Дата:
Сообщение: 64 bit XID / Wraparound / Streaming Replication
Следующее
От: Merlin Moncure
Дата:
Сообщение: Re: execute stored function from ms visual foxpro