Re: 64 bit XID / Wraparound / Streaming Replication - Mailing list pgsql-novice

From Tom Lane
Subject Re: 64 bit XID / Wraparound / Streaming Replication
Date
Msg-id 24303.1336397984@sss.pgh.pa.us
Whole thread Raw
In response to 64 bit XID / Wraparound / Streaming Replication  (Frank Foerster <frankwordsten@googlemail.com>)
List 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 by date:

Previous
From: Frank Foerster
Date:
Subject: 64 bit XID / Wraparound / Streaming Replication
Next
From: Merlin Moncure
Date:
Subject: Re: execute stored function from ms visual foxpro