Re: Fw: postgrepsql vacuum

"wenjing wu" <wuwj@umich.edu> writes:
> Now , I am trying to vacuum the database companion in the standalone model:

> root@head02 /var/lib/pgsql/data/pg_log# su - postgres
> -bash-3.00$  postgres -D /var/lib/pgsql/data

This is defaulting to connecting to database postgres ...

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

... which is not the one you need to vacuum.

> backend> vacuum full

Use a plain vacuum --- vacuum full is uselessly expensive.

            regards, tom lane