Date: Wed, 14 Apr 2010 15:54:02 +0200 From: Christoph Weber-Fahr <cwf-ml@arcor.de> To: freebsd-performance@freebsd.org Subject: Re: is there a problem with the HP SmartArray P410 and/or Postgres on FreeBSD ? Message-ID: <4BC5C8FA.3030505@arcor.de> In-Reply-To: <hq40et$tgo$1@dough.gmane.org> References: <4BC4D46B.9040805@arcor.de> <hq40et$tgo$1@dough.gmane.org>
next in thread | previous in thread | raw e-mail | index | archive | help
Hello,
On 14.04.2010 11:04, Ivan Voras wrote:
> On 04/13/10 22:30, Christoph Weber-Fahr wrote:
>> Hello,
>>
>> on a new HP Proliant DL385 G6 I have a P410 with BBWC and
>> 8 hard drives in RAID5.
>> (BBWC is Battery Backed Write Cache Enabler, and the controller
>> is configured with 300M (75%) write cache).
>>
>> One of the applications we want to run is PostgreSQL (not the top
>> priority, else we would use a different RAID scenario).
>>
>> But before getting the system live, we tested the performance.
>> PostgreSQL gets a whole wopping 80 (!) tps out of this
>> scenario wit pgbench ( -c 5 -t 5000)
> Can you give more details about your hardware? CPU? Memory? File system?
> The "100% sys time" point makes it possible it's not the storage itself
> that is the issue.
CPU is a single AMD Athlon 2427 6-core processor, with 4 Gig RAM.
Filesystem is standard bsd ufs/ffs with softupdates on a 3.2 TB RAID5.
As for 100%sys time, I didn't claim that. I just note the storage
device da0 in the systat -vmstat screen is marked as 100% busy.
> You can also collect more information: I'd recommend with either "iostat
> -x 1" or "gstat".
I'll append some stats.
Regards
Christoph Weber-Fahr
iostat -x 1
extended device statistics
device r/s w/s kr/s kw/s wait svc_t %b
da0 1.1 16.4 15.4 1030.9 1 5.5 7
pass0 0.0 0.0 0.0 0.0 0 0.0 0
extended device statistics
device r/s w/s kr/s kw/s wait svc_t %b
da0 0.0 57.0 0.0 3645.3 1 18.1 100
pass0 0.0 0.0 0.0 0.0 0 0.0 0
extended device statistics
device r/s w/s kr/s kw/s wait svc_t %b
da0 0.0 400.5 0.0 24052.3 1 2.6 96
pass0 0.0 0.0 0.0 0.0 0 0.0 0
extended device statistics
device r/s w/s kr/s kw/s wait svc_t %b
da0 0.0 196.8 0.0 12593.5 1 5.2 97
pass0 0.0 0.0 0.0 0.0 0 0.0 0
extended device statistics
device r/s w/s kr/s kw/s wait svc_t %b
da0 0.0 61.9 0.0 3963.4 1 16.5 98
pass0 0.0 0.0 0.0 0.0 0 0.0 0
extended device statistics
device r/s w/s kr/s kw/s wait svc_t %b
da0 0.0 70.9 0.0 4538.8 1 14.5 99
pass0 0.0 0.0 0.0 0.0 0 0.0 0
extended device statistics
device r/s w/s kr/s kw/s wait svc_t %b
da0 0.0 61.9 0.0 3963.4 1 16.6 100
pass0 0.0 0.0 0.0 0.0 0 0.0 0
extended device statistics
device r/s w/s kr/s kw/s wait svc_t %b
da0 0.0 60.9 0.0 3899.5 1 16.5 97
pass0 0.0 0.0 0.0 0.0 0 0.0 0
extended device statistics
device r/s w/s kr/s kw/s wait svc_t %b
da0 0.0 76.9 0.0 4922.3 1 13.9 101
pass0 0.0 0.0 0.0 0.0 0 0.0 0
extended device statistics
device r/s w/s kr/s kw/s wait svc_t %b
da0 0.0 62.9 0.0 4027.3 1 16.4 100
pass0 0.0 0.0 0.0 0.0 0 0.0 0
gstat
dT: 1.001s w: 1.000s
L(q) ops/s r/s kBps ms/r w/s kBps ms/w %busy Name
0 0 0 0 0.0 0 0 0.0 0.0| acd0
1 68 0 0 0.0 68 4347 14.8 99.4| da0
0 0 0 0 0.0 0 0 0.0 0.0| da0p1
0 0 0 0 0.0 0 0 0.0 0.0| da0p2
0 0 0 0 0.0 0 0 0.0 0.0| da0p3
0 0 0 0 0.0 0 0 0.0 0.0| da0p4
0 0 0 0 0.0 0 0 0.0 0.0| da0p5
1 68 0 0 0.0 68 4347 14.9 99.6| da0p6
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?4BC5C8FA.3030505>