X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 1EEB0DB8B5 for ; Wed, 16 Nov 2005 06:17:09 -0400 (AST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 58197-08 for ; Wed, 16 Nov 2005 10:17:10 +0000 (GMT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from obelix.askesis.nl (laudanum.demon.nl [82.161.125.16]) by svr1.postgresql.org (Postfix) with ESMTP id 1BA38DB73B for ; Wed, 16 Nov 2005 06:17:04 -0400 (AST) Received: obelix.askesis.nl 172.31.0.1 from 172.31.1.8 172.31.1.8 via HTTP with MS-WebStorage 6.0.6249 Received: from Panoramix by obelix.askesis.nl; 16 Nov 2005 11:17:06 +0100 Subject: Re: Performance PG 8.0 on dual opteron / 4GB / 3ware From: Joost Kraaijeveld To: Luke Lonergan Cc: Dave Cramer , Pgsql-Performance In-Reply-To: References: Content-Type: text/plain; charset=iso-8859-13 Content-Transfer-Encoding: quoted-printable Date: Wed, 16 Nov 2005 11:17:05 +0100 Message-Id: <1132136225.5711.4.camel@Panoramix> Mime-Version: 1.0 X-Mailer: Evolution 2.2.3 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.001 required=5 tests=[UNPARSEABLE_RELAY=0.001] X-Spam-Score: 0.001 X-Spam-Level: X-Archive-Number: 200511/268 X-Sequence-Number: 15525 Hi Luke, > It is very important with the 3Ware cards to match the driver to the > firmware revision. > So, if you can get your =B4dd bigfile=A1 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=3D/dev/zero of=3Dbigfile bs=3D8k count=3D1000000 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. --=20 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=20