BUG #11678: database age

Поиск
Список
Период
Сортировка
От sunxin@leyou.com
Тема BUG #11678: database age
Дата
Msg-id 20141016095837.26856.18930@wrigleys.postgresql.org
обсуждение исходный текст
Список pgsql-bugs
Дерево обсуждения 
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 по дате отправления: