GP数据库事务年龄相关

查询表统计数据是出现异常提示

WARNING:  database "mydb" must be vacuumed within 1499616402 transactions  (seg0 bbzx01:40000 pid=22138)
HINT:  To avoid a database shutdown, execute a full-database VACUUM in "mydb".

查看数据库事务年龄

mydb=# SELECT datname,datfrozenxid,age(datfrozenxid) from pg_database order by 1 desc;
  datname  | datfrozenxid |    age    
-----------+--------------+-----------
 template1 |          884 | 212576038
 template0 |          884 | 212576038
 postgres  |          884 | 212576038
 gpperfmon |          884 | 212576038
 mydb     |          884 | 212576038

查看数据库服务参数

mydb=#   show xid_warn_limit;
 xid_warn_limit 
----------------
 500000000
(1 row)

mydb=#   show xid_stop_limit;
 xid_stop_limit 
----------------
 1000000000
(1 row)

一旦年龄超过以上数值，那么就会报warning

WARNING:  database "mydb" must be vacuumed within 149961640