Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 9ABA22E004C for ; Thu, 14 Feb 2008 06:10:48 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 23869-02 for ; Thu, 14 Feb 2008 06:10:38 -0400 (AST) Received: from mail01.enterprisedb.com (mail01.enterprisedb.com [63.246.7.168]) by postgresql.org (Postfix) with ESMTP id AC7542E004B for ; Thu, 14 Feb 2008 06:10:42 -0400 (AST) thread-index: Achu8e4EptS5cG0yRNycMv0FNr0jxg== Received: from [87.127.95.195] ([87.127.95.195]) by mail01.enterprisedb.com with Microsoft SMTPSVC(6.0.3790.3959); Thu, 14 Feb 2008 05:11:13 -0500 Content-Class: urn:content-classes:message Importance: normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.4133 Message-ID: <47B41414.9030004@enterprisedb.com> Date: Thu, 14 Feb 2008 10:12:36 +0000 From: "Greg Stark" User-Agent: Thunderbird 2.0.0.6 (X11/20070728) MIME-Version: 1.0 To: "Tobias Brox" Cc: "Peter Koczan" , "pgsql-performance" Subject: Re: Anyone using a SAN? References: <4544e0330802130856t10582294lfa93bc91e234ed01@mail.gmail.com> <20080213210655.GL9596@mail.nordicbet.com> In-Reply-To: <20080213210655.GL9596@mail.nordicbet.com> Content-Type: text/plain; format=flowed; charset="ISO-8859-1" Content-Transfer-Encoding: 7bit X-OriginalArrivalTime: 14 Feb 2008 10:11:13.0875 (UTC) FILETIME=[EDF8FA30:01C86EF1] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/160 X-Sequence-Number: 28702 Tobias Brox wrote: > [Peter Koczan - Wed at 10:56:54AM -0600] > > The consensus on this list seemed to be that running postgres on SAN is > not cost efficiently - one would get better performance for a lower cost > if the database host is connected directly to the disks - and also, > buying the wrong SAN can cause quite some problems. > That's true about SANs in general. You don't buy a SAN because it'll cost less than just buying the disks and a controller. You buy a SAN because it'll let you make managing it easier. The break-even point has more to do with how many servers you're able to put on the SAN and how often you need to do tricky backup and upgrade procedures than it doeswith the hardware.