"Nick Fankhauser" <nickf@xxxxxxxxxx> writes:
> One other question- when I'm vacuuming, I always get the warning:
> WARNING: some databases have not been vacuumed in <big number> transactions
> HINT: Better vacuum them within <big number> transactions, or you may
> have a wraparound failure.
> I get these even after all DBs except template0 have been freshly vacuumed. Why?
Do your vacuums change the pg_database.datfrozenxid values for the
databases? The only reason I can think of for them not to do so
is if you're not doing them as superuser ...
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
