From: | "Sriram Dandapani" <sdandapani(at)counterpane(dot)com> |
---|---|
To: | <pgsql-admin(at)postgresql(dot)org> |
Subject: | postgres 8.2.3 transaction xid wraparound |
Date: | 2007-03-06 19:51:50 |
Message-ID: | 6992E470F12A444BB787B5C937B9D4DF09A4CBA4@ca-mail1.cis.local |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Karthikeyan Sundaram | 2007-03-06 20:20:56 | pg_dump and pg_dumpall is hanging |
Previous Message | Moritz Bayer | 2007-03-06 08:49:35 | Re: pg_hba.conf & putty |