X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 8F794D1F01B for ; Tue, 4 May 2004 00:47:17 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 46378-09 for ; Tue, 4 May 2004 00:46:56 -0300 (ADT) Received: from wren.rentec.com (unknown [65.213.84.9]) by svr1.postgresql.org (Postfix) with ESMTP id B1771D1F003 for ; Tue, 4 May 2004 00:46:54 -0300 (ADT) Received: from rentec.com (stangesun.rentec.com [172.16.160.106]) by wren.rentec.com (8.12.1/8.12.1) with ESMTP id i443kieu004709; Mon, 3 May 2004 23:46:44 -0400 (EDT) Message-ID: <4097081B.7020006@rentec.com> Date: Mon, 03 May 2004 23:03:55 -0400 From: Alan Stange User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8a) Gecko/20040428 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Joseph Shraibman Cc: "J. Andrew Rogers" , pgsql-performance@postgresql.org Subject: Re: linux distro for better pg performance References: <407E25A6.ADFE4815@t1.unisoftbg.com> <407E909F.9000101@ehpg.net> <1082053706.10823.38.camel@localhost.localdomain> <40970058.3040608@selectacast.net> In-Reply-To: <40970058.3040608@selectacast.net> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200405/17 X-Sequence-Number: 6848 Joseph Shraibman wrote: > J. Andrew Rogers wrote: > >> Do these features make a difference? Far more than you would >> imagine. On one postgres server I just upgraded, we went from a 3Ware >> 8x7200-RPM >> RAID-10 configuration to an LSI 320-2 SCSI 3x10k RAID-5, with 256M > > Is raid 5 much faster than raid 10? On a 4 disk array with 3 data > disks and 1 parity disk, you have to write 4/3rds the original data, > while on raid 10 you have to write 2 times the original data, so > logically raid 5 should be faster. I think this comparison is a bit simplistic. For example, most raid5 setups have full stripes that are more than 8K (the typical IO size in postgresql), so one might have to read in portions of the stripe in order to compute the parity. The needed bits might be in some disk or controller cache; if it's not then you lose. If one is able to perform full stripe writes then the raid5 config should be faster for writes. Note also that the mirror has 2 copies of the data, so that the read IOs would be divided across 2 (or more) spindles using round robin or a more advanced algorithm to reduce seek times. Of course, I might be completely wrong... -- Alan