I vacumm all DB ...except... postgres ones.
I"ll do a vacuum -all tonight
What is you vacuum strategy ?
vacuum everyday and vacuum full analyse ervery week ?
thanks !
Joshua D. Drake wrote:
FM wrote:
Hello after a vacuum full analyse I received this :
WARNING: some databases have not been vacuumed in 1805294030
transactions
HINT: Better vacuum them within 342189617 transactions, or you may
have a wraparound failure.
I read that it's because i do not vacuum DB very often.
Now I vacuum every night but the warning remains.
How can I get rid of this ?
Run a vacuum full on all the database.
Thanks !
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
