some databases have not been vacuumed ...

From: FM <dist-list(at)LEXUM(dot)UMontreal(dot)CA>
To: Mailing List Postgres-Admin <pgsql-admin(at)postgresql(dot)org>
Subject: some databases have not been vacuumed ...
Date: 2005-08-01 19:35:38
Message-ID: 42EE798A.5040305@lexum.umontreal.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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 ?

Thanks !

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Joshua D. Drake 2005-08-01 19:44:39 Re: some databases have not been vacuumed ...
Previous Message CG 2005-08-01 17:28:32 Re: Indexes on RAM disk = insanity?