How to detect invisible rows caused by the relfrozenxid bug?

From: Omar Kilani <omar(dot)kilani(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: How to detect invisible rows caused by the relfrozenxid bug?
Date: 2013-12-05 21:14:09
Message-ID: CA+8F9hjT8BMksUs21CQQXmJ4+t9-Wm3PTE+46yJ+Ow=ZhdFshg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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.

Thanks!

Regards,
Omar

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Paquier 2013-12-05 21:50:18 Re: Regression tests failing if not launched on db "regression"
Previous Message Heikki Linnakangas 2013-12-05 21:06:33 Re: Dynamic Shared Memory stuff