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 4DF939DCC84 for ; Mon, 20 Mar 2006 17:48:02 -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 82989-02 for ; Mon, 20 Mar 2006 17:48:03 -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 B18019DCBDB for ; Mon, 20 Mar 2006 17:47:59 -0400 (AST) Received: (qmail 62178 invoked from network); 20 Mar 2006 22:10:42 -0000 Received: from unknown (HELO ?192.168.10.124?) (200.13.161.68) by asgard1.americatelsal.com with SMTP; 20 Mar 2006 22:10:42 -0000 Message-ID: <441F23ED.1080302@123.com.sv> Date: Mon, 20 Mar 2006 15:51:41 -0600 From: Miguel User-Agent: Mozilla Thunderbird 1.0.7 (Windows/20050923) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Luke Lonergan CC: Postgresql Performance Subject: Re: Best OS & Configuration for Dual Xeon w/4GB & Adaptec References: In-Reply-To: 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.014 required=5 tests=[AWL=0.014] X-Spam-Score: 0.014 X-Spam-Level: X-Archive-Number: 200603/347 X-Sequence-Number: 17784 Luke Lonergan wrote: >>>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 >>> >>> >>> >>I have 6 ultra a320 72G 10k discs >> >> > >Yah - ouch. With 6 drives in a RAID10, you should expect 3 drives worth of >sequential scan performance, or anywhere from 100MB/s to 180MB/s. You're >getting from half to 1/3 of the performance you'd get with a decent raid >controller. > >If you add a simple SCSI adapter like the common LSI U320 adapter to your >DL380G3 and then run software RAID, you will get more than 150MB/s with less >CPU consumption. I'd also expect you'd get down to about 2ms access times. > >This might not be easy for you to do, and you might prefer hardware RAID >adapters, but I don't have a recommendation for you there. I'd stay away >from the HP line. > > > This is my new postgreql 8.1.3 server, so i have many options (in fact, any option) to choose from, i want maximum performance, if i undestood you well, do you mean using something like vinum? i forgot to mention that the 6 discs are in a MSA500 G2 external storadge, additionally i have two 36G a320 10k in raid 10 for the os installed in the server slots. --- Miguel