查询表统计数据是出现异常提示
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