Thread: BUG #11678: database age

BUG #11678: database age

From
sunxin@leyou.com
Date:
The following bug has been logged on the website:

Bug reference:      11678
Logged by:          sunxin
Email address:      sunxin@leyou.com
PostgreSQL version: 9.1.4
Operating system:   debian6
Description:

/*
 * Do not truncate CLOG if we seem to have suffered wraparound already;
 * the computed minimum XID might be bogus.  This case should now be
 * impossible due to the defenses in GetNewTransactionId, but we keep the
 * test anyway.
 */


追心 2014/10/13 9:05:25
                             relname                             |
relnamespace |     age     | relfrozenxid
-----------------------------------------------------------------+--------------+-------------+--------------
 pg_authid                                                       |
11 | -1916545230 |   2036829257
 sl_log_2                                                        |
1348563995 |       59520 |    120224507
 sl_log_1                                                        |
4286920530 |       59520 |    120224507
 sl_log_1                                                        |
4202585842 |       59520 |    120224507



  datname   |     age     | datfrozenxid | available_xids
------------+-------------+--------------+----------------
 postgres   |  1074730916 |   3340497609 |     1071752732
  testdb     | -1916568028 |   2036829257 |     4063051676