[BUGS] BUG #6291: Xid epoch is not updated properly

2011-11-13 Thread Daniel Farina
The following bug has been logged online: Bug reference: 6291 Logged by: Daniel Farina Email address: dan...@heroku.com PostgreSQL version: 9.0.5 Operating system: Ubuntu 10.04 Description:Xid epoch is not updated properly Details: We have on hand a database that

Re: [BUGS] BUG #6291: Xid epoch is not updated properly

2011-11-13 Thread Tom Lane
Daniel Farina dan...@heroku.com writes: We have on hand a database that makes heavy use of the txid_snapshot family of functions, and recently it just passed its 4^32 transaction mark. Unfortunately, upon wraparound the xid epoch appears to not have been incremented, remaining at 0. I failed

Re: [BUGS] BUG #6291: Xid epoch is not updated properly

2011-11-13 Thread Daniel Farina
On Sun, Nov 13, 2011 at 3:27 PM, Tom Lane t...@sss.pgh.pa.us wrote: Daniel Farina dan...@heroku.com writes: We have on hand a database that makes heavy use of the txid_snapshot family of functions, and recently it just passed its 4^32 transaction mark. Unfortunately, upon wraparound the xid