Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id DFFE1650301 for ; Thu, 28 Aug 2008 18:30:46 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 06238-01-2 for ; Thu, 28 Aug 2008 18:30:38 -0300 (ADT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by postgresql.org (Postfix) with ESMTP id AE1FB64FD3B for ; Thu, 28 Aug 2008 18:29:54 -0300 (ADT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.14.1/8.14.1) with ESMTP id m7SLTo2O005914 for ; Thu, 28 Aug 2008 18:29:50 -0300 (ADT) (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.14.1/8.14.1/Submit) id m7SLT7jg005671 for pgsql-performance@postgresql.org; Thu, 28 Aug 2008 18:29:07 -0300 (ADT) (envelope-from news) From: cluster X-Newsgroups: pgsql.performance Subject: Re: Best hardware/cost tradoff? Date: Thu, 28 Aug 2008 23:29:09 +0200 Organization: Hub.Org Networking Services Lines: 15 Message-ID: References: <064701c90949$51d117d0$8f01010a@iptel.com.ar> <48B709A5.3090906@emolecules.com> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@news.hub.org User-Agent: Thunderbird 2.0.0.16 (X11/20080724) In-Reply-To: <48B709A5.3090906@emolecules.com> To: pgsql-performance@postgresql.org X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200808/392 X-Sequence-Number: 31273 Thanks for all your replies! They are enlightening. I have some additional questions: 1) Would you prefer a) 5.4k 2" SATA RAID10 on four disks or b) 10k 2" SAS RAID1 on two disks? (Remember the lots (!) of random reads) 2) Should I just make one large partition of my RAID? Does it matter at all? 3) Will I gain much by putting the OS on a saparate disk, not included in the RAID? (The webserver and database would still share the RAID - but I guess the OS will cache my (small) web content in RAM anyway). Thanks again!