From: | "Joey K(dot)" <pguser(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Question about VACUUM |
Date: | 2008-10-25 15:21:40 |
Message-ID: | 467669b30810250821u131b07b5y961aae33f4d07070@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello all,
I inherited a 8.1.x database of size 200GB. This database hasn't been
maintained much (autovac is enabled though).
I been trying to VACUUM this db for the past few days for a couple of
hours/day. The server runs 24x7 so continuous maintenance is not possible
(this is the last resort).
My questions are,
> Is it possible to estimate how long VACUUM on a table might take?
> The table size is growing as "VACUUM" is being performed. I assume I need
reindex after VACUUM is complete.
> I run VACUUM from psql and I Ctrl-C it to turn it off is this acceptable?
> maintenance_work_mem is at 64MB and shared_buffers at 2GB. Should I
dedicate more memory to maintenance_work_mem to speedup VACUUM?
The server is a Intel Xeon 3.0GHz with 4GB RAM and RAID-5 (Yes I know).
Thanks in advance,
Steve
From | Date | Subject | |
---|---|---|---|
Next Message | Hannes Dorbath | 2008-10-25 15:46:03 | Re: Question about VACUUM |
Previous Message | Ati Rosselet | 2008-10-25 15:12:28 | again... |