| From: | "Gregory S(dot) Williamson" <gsw(at)globexplorer(dot)com> |
|---|---|
| To: | "FM" <dist-list(at)lexum(dot)umontreal(dot)ca>, "Mailing List Postgres-Admin" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: some databases have not been vacuumed ... |
| Date: | 2005-08-01 20:29:14 |
| Message-ID: | 71E37EF6B7DCC1499CEA0316A256832801D4C6EE@loki.wc.globexplorer.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Did you vacuum the template1 database as well as whatever databases you have created ?
HTH,
Greg Williamson
DBA
GlobeXplorer LLC
-----Original Message-----
From: pgsql-admin-owner(at)postgresql(dot)org on behalf of FM
Sent: Mon 8/1/2005 12:35 PM
To: Mailing List Postgres-Admin
Cc:
Subject: [ADMIN] some databases have not been vacuumed ...
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 !
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
!DSPAM:42ee7af1176271374616439!
| From | Date | Subject | |
|---|---|---|---|
| Next Message | FM | 2005-08-01 20:51:50 | Re: some databases have not been vacuumed ... |
| Previous Message | Joshua D. Drake | 2005-08-01 19:44:39 | Re: some databases have not been vacuumed ... |