Re: Should autovacuum do a database wide vacuum near transaction limit?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "John Lister" <john(dot)lister-ps(at)kickstone(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Should autovacuum do a database wide vacuum near transaction limit?
Date: 2011-01-21 23:40:38
Message-ID: 2081.1295653238@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"John Lister" <john(dot)lister-ps(at)kickstone(dot)com> writes:
> On another bizarre note, A database wide vacuum has just finished, but I'm
> still getting the warnings:

> GMT WARNING: database "backend" must be vacuumed within 10205310
> transactions

Did you do that vacuum as a superuser?

regards, tom lane

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message John Lister 2011-01-21 23:42:31 Re: Should autovacuum do a database wide vacuum near transaction limit?
Previous Message John Lister 2011-01-21 23:33:36 Re: Should autovacuum do a database wide vacuum near transaction limit?