|
Its 8.1 and I'm doing a Vacuum using the vacuumdb program. Thanks Matt, might be time for an upgrade. > Date: Tue, 5 Aug 2008 11:21:44 -0400 > From: matthew@xxxxxxxx > To: aklaver@xxxxxxxxxxx > CC: pgsql-general@xxxxxxxxxxxxxx; redsmurfau@xxxxxxx > Subject: Re: [GENERAL] Vacuum Vs Vacuum Full > > Adrian Klaver wrote: > > On Monday 04 August 2008 11:04:00 pm Robert Shaw wrote: > >> "WARNING: database "mydb" must be vacuumed within 177009986 transactions > >> HINT: To avoid a database shutdown, execute a full-database VACUUM in > >> "mydb"."Which is reason I ask the question, is full vacuum backup useful > >> for anything other than reclaiming disk space. > > > > Actually its not asking for a VACUUM FULL but a VACUUM of the full database, > > instead of selected tables. > > > > See below for complete details > > http://www.postgresql.org/docs/8.3/interactive/routine-vacuuming.html#VACUUM-FOR-WRAPAROUND > > > BTW, what version of PostgreSQL is this? Database-wide vacuum is no > longer required for XID wraparound issues. I think this was an 8.3 > change but might have happened in 8.2, I don't remember. > > Matt Sell your car for just $40 at CarPoint.com.au It's simple! |
