| From: | Andrew Sullivan <ajs(at)crankycanuck(dot)ca> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Vacuums taking forever :( |
| Date: | 2009-02-03 13:16:33 |
| Message-ID: | 20090203131633.GC48697@shinkuro.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, Feb 03, 2009 at 08:46:37PM +0800, Phoenix Kiula wrote:
> The autovacuum was clearly not enough, so we also have a crontab that
> vacuums the tables every hour. This is PG 8.2.9.
How did you determine this? What was it not enough for? Which
tables? Why didn't you tune autovacuum differently?
I think the cron jobs are your problem.
> These cron jobs are taking over 35 minutes for a vacuum! What's the
> use of a vacuum if it takes that long, and the DB performance is
> tragic in the meantime?
VACUUM uses disk bandwidth. I suspect you are causing part of your
problem.
A
--
Andrew Sullivan
ajs(at)crankycanuck(dot)ca
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Phoenix Kiula | 2009-02-03 13:44:21 | Re: Vacuums taking forever :( |
| Previous Message | Andreas Wenk | 2009-02-03 13:09:53 | Re: Vacuums taking forever :( |