Re: Performance PG 8.0 on dual opteron / 4GB / 3ware - Mailing list pgsql-performance

From Joost Kraaijeveld
Subject Re: Performance PG 8.0 on dual opteron / 4GB / 3ware
Date
Msg-id 1132136225.5711.4.camel@Panoramix
Whole thread Raw
In response to Re: Performance PG 8.0 on dual opteron / 4GB / 3ware  ("Luke Lonergan" <llonergan@greenplum.com>)
Responses Perl DBD and an alarming problem
List pgsql-performance
Hi Luke,


> It is very important with the 3Ware cards to match the driver to the
> firmware revision.
> So, if you can get your “dd bigfile” test to write data at 50MB/s+
> with a blocksize of 8KB, you should be doing well enough.

I recompiled my kernel, added the driver and:

jkr@Panoramix:~$ dmesg | grep 3w
3ware 9000 Storage Controller device driver for Linux v2.26.03.019fw.
scsi4 : 3ware 9000 Storage Controller
3w-9xxx: scsi4: Found a 3ware 9000 Storage Controller at 0xfd8ffc00,
IRQ: 28.
3w-9xxx: scsi4: Firmware FE9X 2.08.00.005, BIOS BE9X 2.03.01.052, Ports:
8.


jkr@Panoramix:~/tmp$ dd if=/dev/zero of=bigfile bs=8k count=1000000
1000000+0 records in
1000000+0 records out
8192000000 bytes transferred in 200.982055 seconds (40759858 bytes/sec)

Which is an remarkable increase in speed (38.9 MB/sec vs 25.7 MB/sec).

Thanks for your suggestions.


--
Groeten,

Joost Kraaijeveld
Askesis B.V.
Molukkenstraat 14
6524NB Nijmegen
tel: 024-3888063 / 06-51855277
fax: 024-3608416
e-mail: J.Kraaijeveld@Askesis.nl
web: www.askesis.nl



pgsql-performance by date:

Previous
From: Joost Kraaijeveld
Date:
Subject: Re: Performance PG 8.0 on dual opteron / 4GB / 3ware
Next
From: William Yu
Date:
Subject: Re: Hardware/OS recommendations for large databases (