Re: PostgreSQL 64 Bit XIDs - Transaction IDs

On Fri, 23 Mar 2012, Tom Lane wrote:

> 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.

That were all small writing transactions benchmarking the database (with
the corrected values discussed).

Ciao,
Gerhard

--
http://www.wiesinger.com/