On Thu, Dec 5, 2013 at 4:14 PM, Omar Kilani <omar.kil...@gmail.com> 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 (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers