pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: ddgs <gsmaths@gmail.com>
To: pgsql-performance@postgresql.org
Subject: Re: count on transaction ID
Date: Mon, 12 Mar 2012 08:46:53 -0700 (PDT)
Message-ID: <1331567213547-5558198.post@n5.nabble.com> (raw)
In-Reply-To: <4F5DC49D02000025000460F6@gw.wicourts.gov>
References: <1331307029713-5550894.post@n5.nabble.com>
	<4F5DC49D02000025000460F6@gw.wicourts.gov>

It is just a simple idea syntax, not the exact one. 
Anyway, I am wonder how to get the 2^31 transaction IDs to cause the failure
But I get the wraparound error warning when I delete a large no. of rows.
So the wraparound failure is due to what reason, that I still have no idea
(at least not the transaction limit, I guess) 

--
View this message in context: http://postgresql.1045698.n5.nabble.com/count-on-transaction-ID-tp5550894p5558198.html
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.



view thread (6+ messages)  latest in thread

Message-ID: <1331567213547-5558198.post@n5.nabble.com>
Permalink:  ../1331567213547-5558198.post@n5.nabble.com/
Also on:    postgresql.org/message-id/1331567213547-5558198.post@n5.nabble.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: gsmaths@gmail.com
  Subject: Re: count on transaction ID
  In-Reply-To: <1331567213547-5558198.post@n5.nabble.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox