Postgres Pro
Downloads
Home   >   mailing lists

How to detect invisible rows caused by the relfrozenxid bug? - Mailing list pgsql-hackers

From Omar Kilani
Subject How to detect invisible rows caused by the relfrozenxid bug?
Date
Msg-id CA+8F9hjT8BMksUs21CQQXmJ4+t9-Wm3PTE+46yJ+Ow=ZhdFshg@mail.gmail.com
Whole thread Raw
Responses Re: How to detect invisible rows caused by the relfrozenxid bug?
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: Dynamic Shared Memory stuff
Next
From: Michael Paquier
Date:
Subject: Re: Regression tests failing if not launched on db "regression"