I have been using postgres 8.1 for a while now with large
databases (over 300-400G). The biggest issue I have faced is the routine
vacuumdb command that takes care of the transaction id wraparound problem (I
run this once a week on each postgres box and it takes about 24-48 hours
depending on the load and size of databse). (autovacuum just doesn’t work
for me as I need to routinely shut down postgres briefly and restart) I run the following command to determine when to kick of
vacuuming.. Select datname,age(datfrozenxid) from pg_database With 8.2.3….what is the query I need to run to check
age of xid for wraparound purposes (I read from the docs that it is now
maintained on a per-table basis..does this mean if I were to vacuum tables
individually..i would not need to run a vacuumdb on the database cluster?) Thanks Sriram |