Re: Vacuum Full (PG 8.1) - Urgent help needed - Cancel & transaction "liberation"

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Alexandre Leclerc <aleclerc(at)ipso(dot)ca>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Vacuum Full (PG 8.1) - Urgent help needed - Cancel & transaction "liberation"
Date: 2010-04-16 20:02:27
Message-ID: 14240.1271448147@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Alexandre Leclerc <aleclerc(at)ipso(dot)ca> writes:
> I'm always getting:
> WARNING: db "template1" must be vacuumed within 999593 transactions
> HINT: To avoid... execute a full-database VACUUM in "template1"
> ... (repeated many times until 999568)

Yeah, I think you will get that bleat once per table processed, until
you've resolved the problem (which will likely take vacuuming each
database in the installation). Don't sweat it.

regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message robin 2010-04-16 20:02:34 Re: Vacuum Full (PG 8.1) - Urgent help needed - Cancel & transaction "liberation"
Previous Message Alexandre Leclerc 2010-04-16 19:56:03 Re: Vacuum Full (PG 8.1) - Urgent help needed - Cancel & transaction "liberation"