On 10/5/15 5:00 PM, Michael Chau wrote:
So, do I need to run vacuum freeze on those tables? Also, if
autovacuum_freeze_max_age is commented, does it still mean that the
default is 200M?
Yes, and unless you're running a very high transaction rate you probably
don't need to mess with it. Likewis
Hi,
Last Friday, I ran :
postgres=# select max(age(datfrozenxid)) from pg_database;
max
42579490
and then I ran :
SELECT relname, age(relfrozenxid) as xid_age,
pg_size_pretty(pg_table_size(oid)) as table_size
FROM pg_class
WHERE relkind = 'r' and pg_table_size(oid) > 1073741824
ORDER BY ag
