"wenjing wu" <[EMAIL PROTECTED]> writes:
> Now , I am trying to vacuum the database companion in the standalone model:
> [EMAIL PROTECTED] /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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
