is there a problem with the HP SmartArray P410 and/or Postgres
on FreeBSD ?
Christoph Weber-Fahr
cwf-ml at arcor.de
Wed Apr 14 13:54:06 UTC 2010
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
More information about the freebsd-performance
mailing list