is there a problem with the HP SmartArray P410 and/or Postgres
on FreeBSD ?
Ivan Voras
ivoras at freebsd.org
Wed Apr 14 14:10:54 UTC 2010
On 04/14/10 15:54, Christoph Weber-Fahr wrote:
> 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.
Hi,
Ok, thanks for clarifying that. In this case, and looking at the stats
below, I think you are right - something really is problematic with your
storage.
Unfortunately, I don't clearly see what could be the issue, except if
your BBU is not enabled or the controller isn't set for write-through.
I have a P400 on a machine and it works as expected (on 6 drives in
RAID-10). What are your sequential read and write rates? Try testing
with bonnie++. I get > 200 MB/s in either direction but rewrite rates of
38 MB/s. It also reports seek rate of ~~850/s.
> 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
> _______________________________________________
> freebsd-performance at freebsd.org mailing list
> http://lists.freebsd.org/mailman/listinfo/freebsd-performance
> To unsubscribe, send any mail to "freebsd-performance-unsubscribe at freebsd.org"
>
More information about the freebsd-performance
mailing list