X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 5E9899DC86F for ; Mon, 20 Mar 2006 16:49:07 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 72911-08 for ; Mon, 20 Mar 2006 16:49:08 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from asgard1.americatelsal.com (asgard.americatelsal.com [200.13.161.7]) by postgresql.org (Postfix) with ESMTP id EA4E09DC80E for ; Mon, 20 Mar 2006 16:49:04 -0400 (AST) Received: (qmail 55136 invoked from network); 20 Mar 2006 21:11:46 -0000 Received: from unknown (HELO ?192.168.10.124?) (200.13.161.68) by asgard1.americatelsal.com with SMTP; 20 Mar 2006 21:11:46 -0000 Message-ID: <441F161D.7010502@123.com.sv> Date: Mon, 20 Mar 2006 14:52:45 -0600 From: Miguel User-Agent: Mozilla Thunderbird 1.0.7 (Windows/20050923) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Vivek Khera CC: Postgresql Performance Subject: Re: Best OS & Configuration for Dual Xeon w/4GB & Adaptec References: <20060317221116.GA14661@juniper.net> <8F6490E1-64E2-406B-A559-7DA8BA1EB197@khera.org> In-Reply-To: <8F6490E1-64E2-406B-A559-7DA8BA1EB197@khera.org> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[none] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200603/343 X-Sequence-Number: 17780 Vivek Khera wrote: > > On Mar 17, 2006, at 5:11 PM, Kenji Morishige wrote: > >> In summary, my questions: >> >> 1. Would running PG on FreeBSD 5.x or 6.x or Linux improve performance? > > > FreeBSD 6.x will definitely get you improvements. Many speedup > improvements have been made to both the generic disk layer and the > specific drivers. However, the current best of breed RAID controller > is the LSI 320-x (I use 320-2X). I have one box into which this > card will not fit (Thanks Sun, for making a box with only low-profile > slots!) so I use an Adaptec 2230SLP card in it. Testing shows it is > about 80% speed of a LSI 320-2x on sequential workload (load DB, run > some queries, rebuild indexes, etc.) > > If you do put on FreeBSD 6, I'd love to see the output of "diskinfo - > v -t" on your RAID volume(s). > Not directly related ... i have a HP dl380 g3 with array 5i controlled (1+0), these are my results shiva2# /usr/sbin/diskinfo -v -t /dev/da2s1d /dev/da2s1d 512 # sectorsize 218513555456 # mediasize in bytes (204G) 426784288 # mediasize in sectors 52301 # Cylinders according to firmware. 255 # Heads according to firmware. 32 # Sectors according to firmware. Seek times: Full stroke: 250 iter in 1.138232 sec = 4.553 msec Half stroke: 250 iter in 1.084474 sec = 4.338 msec Quarter stroke: 500 iter in 1.690313 sec = 3.381 msec Short forward: 400 iter in 0.752646 sec = 1.882 msec Short backward: 400 iter in 1.306270 sec = 3.266 msec Seq outer: 2048 iter in 0.766676 sec = 0.374 msec Seq inner: 2048 iter in 0.803759 sec = 0.392 msec Transfer rates: outside: 102400 kbytes in 2.075984 sec = 49326 kbytes/sec middle: 102400 kbytes in 2.100510 sec = 48750 kbytes/sec inside: 102400 kbytes in 2.042313 sec = 50139 kbytes/sec is this good enough?