Search Postgresql Archives

vacuum confusion

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



I've got a 7.4.6 db running on linux where we've been vacuuming "full" the database each night, and have recently switched to "vacuum analyse" instead.

We keep seeing this message at the end of the vacuum run:

WARNING: some databases have not been vacuumed in 2013308218 transactions
HINT: Better vacuum them within 134175429 transactions, or you may have a wraparound failure.
VACUUM


Why are we seeing this message when the only databases in this cluster is the one we are vacuuming (each night), and template0 and template1?

Is there something that we're not doing right?

John Sidney-Woollett

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@xxxxxxxxxxxxxx

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux