On Tuesday 29 July 2008, "Francisco Reyes" <[EMAIL PROTECTED]> wrote: > On 2:53 pm 07/29/08 Alan Hodgson <[EMAIL PROTECTED]> wrote: > > --sar 2 30 > > Linux 2.6.9-42.ELsmp (trans03) 07/29/2008 > > 12:58:09 PM CPU %user %nice %system %iowait %idle > 12:58:11 PM all 12.44 0.00 0.06 0.00 87.50 > 12:58:13 PM all 12.44 0.00 0.00 0.06 87.50 > 12:58:15 PM all 12.49 0.00 0.06 0.00 87.45 > 12:58:17 PM all 12.43 0.00 0.06 1.62 85.88 > 12:58:19 PM all 12.38 0.00 0.06 0.00 87.55 > 12:58:21 PM all 12.43 0.00 0.12 0.00 87.45 > 12:58:23 PM all 12.50 0.00 0.00 0.00 87.50 > 12:58:25 PM all 12.42 0.00 0.12 0.00 87.45 > > Quadcore machine. Not using not even 100% of one core. > Disk subsystem doesn't seem to be issue (no iowait).
That looks an awful lot like pegged 1/8th usage to me ... are you sure you only have 4 cores? Hyper-threading? > > Based on a few links I read I thought that, holding everything else > constant, increasing maintenance_work_mem would have helped. Yeah, but it didn't. -- Alan -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
