Postgres Pro
Downloads
Home   >   mailing lists

BUG #11678: database age - Mailing list pgsql-bugs

From sunxin@leyou.com
Subject BUG #11678: database age
Date
Msg-id 20141016095837.26856.18930@wrigleys.postgresql.org
Whole thread Raw
List pgsql-bugs
Tree view 
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

pgsql-bugs by date:

Previous
From: Andres Freund
Date:
Subject: Re: BUG #10675: alter database set tablespace and unlogged table
Next
From: kentoj@gmail.com
Date:
Subject: BUG #11680: PostgreSQL JDBC Driver issue