| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "wenjing wu" <wuwj(at)umich(dot)edu> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Fw: postgrepsql vacuum |
| Date: | 2008-06-12 15:29:56 |
| Message-ID: | 9764.1213284596@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
"wenjing wu" <wuwj(at)umich(dot)edu> writes:
> Now , I am trying to vacuum the database companion in the standalone model:
> root(at)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Zoltan Boszormenyi | 2008-06-12 15:31:37 | Re: Heavily fragmented table and index data in 8.0.3 |
| Previous Message | Tom Lane | 2008-06-12 15:21:15 | Re: Heavily fragmented table and index data in 8.0.3 |