Re: BUG #5067: vacuum problem - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #5067: vacuum problem
Date
Msg-id 11225.1253403181@sss.pgh.pa.us
Whole thread Raw
In response to BUG #5067: vacuum problem  ("Pasquale" <pasquale.napolitano@gmail.com>)
List pgsql-bugs
"Pasquale" <pasquale.napolitano@gmail.com> writes:
> I don't connect any more to postres db because postgres needs to vacuum
> operation.
> Then, i use a standalone backend to connect to postgres db.
> Now i'm im in backend> and i write VACUUM FULL.

You don't really need VACUUM FULL, only VACUUM.

> I have this message:

> WARNING: database "postgres" must be vacuumed within 999455 transactions
> HINT: To avoid a database shutdown, execute a full-database VACUUM in
> "postgres".
>   999453

It's not an error, only a warning.  You'll get a couple of those for
each table in the VACUUM, but after you finish it should stop complaining.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: notice on explicit primary key or index name
Next
From: "Paulo"
Date:
Subject: BUG #5068: LIKE