"wenjing wu" <wuwj@xxxxxxxxx> 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
