From: | "MG" <pgsql-general(at)carladata(dot)de> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | WARNING: some databases have not been vacuumed in 1953945422 transactions |
Date: | 2007-02-15 08:14:55 |
Message-ID: | 001201c750d9$60016d20$340aa8c0@geisslinger |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello,
we are using PostgreSQL 8.0.3 and have two databases in one cluster. db1 and db2.
Each night a shell script is being executed.
vacuumdb --analyze -U cmduser db1
vacuumdb --analyze -U cmduser db2
The last weeks the following warnings are given out:
WARNING: some databases have not been vacuumed in 1953945422 transactions
HINT: Better vacuum them within 193538225 transactions, or you may have a wraparound failure.
Now I made the sql-statement:
SELECT datname, age(datfrozenxid) FROM pg_database;
Yesterday I got this result:
datname age
db1 1.090.080.531
db2 1.940.858.511
template1 1.940.858.511
template0 1.940.858.511
Today I got the following result:
datname age
db1 1.075.558.667
db2 1.075.513.031
template1 1.955.716.521
template0 1.955.716.521
Why are there changes of the databases template1 and template0 ?!?
Is this critical?
Regards
Michaela
From | Date | Subject | |
---|---|---|---|
Next Message | RPK | 2007-02-15 08:29:29 | Option to undo last update on table. |
Previous Message | Tadej Kanizar | 2007-02-15 06:23:32 | Multi DB performance test |