Re: dbt2 NOTPM numbers

From: PFC <lists(at)peufeu(dot)com>
To: "Markus Schiltknecht" <markus(at)bluegap(dot)ch>, "Heikki Linnakangas" <heikki(at)enterprisedb(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: dbt2 NOTPM numbers
Date: 2007-06-04 16:47:20
Message-ID: op.tteow6v7cigqcu@apollo13
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


> I'll run a bonnie++ first. As the CPUs seem to be idle most of the time
> (see the vmstat.out below), I'm suspecting the RAID or disks.

You have a huge amount of iowait !
Did you put the xlog on a separate disk ?
What filesystem do you use ?
Did you check that your BBU cache works ?

For that run a dumb script which does INSERTS in a test table in
autocommit mode ; if you get (7200rpm / 60) = 120 inserts / sec or less,
the good news is that your drives don't lie about fsync, the bad news is
that your BBU cache isn't working...

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Douglas J Hunley 2007-06-04 17:05:12 Re: upgraded to pgsql 8.2.4, getting worse performance then 7.4.x
Previous Message Markus Schiltknecht 2007-06-04 15:26:38 Re: dbt2 NOTPM numbers