Artificially increase TransactionID?

From: "Robert A(dot) Klahn" <robert(at)kint(dot)org>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Artificially increase TransactionID?
Date: 2007-10-11 00:57:57
Message-ID: E7E57841-7D2F-482E-A0A1-76AEE2988329@kint.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Greetings:

I am interested in increasing the PostgreSQL TransactionID, as part
of testing a (yet another) replication system that I am working on.
(http://bruce.codehaus.org/ for the interested). I would like to test
what happens when the transactionID crosses 2^31 and when it wraps
around at 2^32-1. Other than running "select now()" 2^31 times, is
there a practical way to raise the transactionID by large amounts?

I need to test against Pg 8.1.X and 8.2.X, and probably 8.3 while Im
at it.

Many thanks in advance.....Bob.

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Joshua D. Drake 2007-10-11 01:20:05 Re: Artificially increase TransactionID?
Previous Message Tom Lane 2007-10-11 00:20:13 Plan invalidation vs temp sequences