Re: PostgreSQL 64 Bit XIDs - Transaction IDs

Merlin Moncure <mmoncure@gmail.com> writes:
> On Fri, Mar 23, 2012 at 11:35 AM, Gerhard Wiesinger <lists@wiesinger.com> wrote:
>> So I think XID overflow should be planned for one of the next PostgreSQL
>> releases.

> two mitigating factors:
> 1. read only transactions do not increment xid counter

Yes.  Ask your admin what his throughput of *data modifying*
transactions is.  I'll bet that number is a few orders of magnitude
smaller again.

> 2. xid wraparound counter is per table.

That unfortunately isn't so, the XID counter is global to an installation.

            regards, tom lane