Postgres Pro
Downloads
Home   >   mailing lists

Re: Should autovacuum do a database wide vacuum near transaction limit? - Mailing list pgsql-admin

From Tom Lane
Subject Re: Should autovacuum do a database wide vacuum near transaction limit?
Date
Msg-id 2081.1295653238@sss.pgh.pa.us
Whole thread Raw
In response to Re: Should autovacuum do a database wide vacuum near transaction limit?  ("John Lister" <john.lister-ps@kickstone.com>)
Responses Re: Should autovacuum do a database wide vacuum near transaction limit?  (John Lister <john.lister@kickstone.com>)
List pgsql-admin
Tree view 
"John Lister" <john.lister-ps@kickstone.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

pgsql-admin by date:

Previous
From: "John Lister"
Date:
Subject: Re: Should autovacuum do a database wide vacuum near transaction limit?
Next
From: "John Lister"
Date:
Subject: Re: Should autovacuum do a database wide vacuum near transaction limit?