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

From: "John Lister" <john(dot)lister(at)kickstone(dot)com>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Should autovacuum do a database wide vacuum near transaction limit?
Date: 2011-01-21 23:42:31
Message-ID: F4C8E4FB28FD48AD860E030A0A27BC62@squarepi.com
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?

yes

John

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message John Lister 2011-01-22 09:27:32 Re: Should autovacuum do a database wide vacuum near transaction limit?
Previous Message Tom Lane 2011-01-21 23:40:38 Re: Should autovacuum do a database wide vacuum near transaction limit?