Re: PostgreSQL 64 Bit XIDs - Transaction IDs - Mailing list pgsql-general

From Gerhard Wiesinger
Subject Re: PostgreSQL 64 Bit XIDs - Transaction IDs
Date
Msg-id alpine.LFD.2.02.1203232012240.10155@bbs.intern
Whole thread Raw
In response to Re: PostgreSQL 64 Bit XIDs - Transaction IDs  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
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/

pgsql-general by date:

Previous
From: Gerhard Wiesinger
Date:
Subject: Re: PostgreSQL 64 Bit XIDs - Transaction IDs
Next
From:
Date:
Subject: Change the default [tgenabled] for new "internal" triggers ?