From: | Roger Ging <rging(at)musicreports(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Vacuum wait time problem |
Date: | 2009-02-13 17:20:00 |
Message-ID: | 4995ABC0.4090401@musicreports.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi,
I'm running vacuum full analyze verbose on a table with 20million rows
and 11 indexes. In top, I'm seeing [pdflush] and postgres: writer
process each using diferent cpu cores, with wait time well above 90% on
each of them. The vacuum has been running for several hours, and the
last thing to show on screen, over an hour ago, was :
DETAIL: 8577281 index row versions were removed.
736 index pages have been deleted, 736 are currently reusable.
CPU 7.57s/52.52u sec elapsed 381.70 sec.
That's the last index
The vacuum process itself is using less than 2% of a core.
The pg version is 8.3.1 running on Suse. Hardware is 2X dual core
Opterons, 16 GB RAM, 24 drives in RAID 50
It would seem to me that the system is extremely IO bound, but I don't
know how to find out what specifically is wrong here. Any advice
greatly appreciated.
--
Roger Ging
--
From | Date | Subject | |
---|---|---|---|
Next Message | John Lister | 2009-02-13 17:57:11 | Re: Database corruption help |
Previous Message | Tom Lane | 2009-02-13 16:28:28 | Re: Database corruption help |