No. Vacuum full should not be necessary on a properly configured server. See: http://www.postgresql.org/docs/8.0/static/maintenance.html On Mon, 2005-08-01 at 15:51, FM wrote: > 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
