On Thu, Dec 5, 2013 at 4:14 PM, Omar Kilani <[email protected]> wrote: > Hi, > > How would one go about detecting whether they've lost rows due to the > relfrozenxid? > > Unfortunately running 'SELECT txid_current() < 2^31' on our DB returns > false, and I'm a little bit worried, since we've been seeing some > WeirdStuff(tm) lately. > > We're "only" 200M txids or so past 2^31. >
We've been working on coming up with a way to determine this, and I think we're pretty close, so if you can hang tight for a bit, hopefully we can post something. That said, if anyone else has come up with a method, I'd be interested in looking at it. Robert Treat play: xzilla.net work: omniti.com -- Sent via pgsql-hackers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
