X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 62D7AD1B181 for ; Tue, 20 Jul 2004 05:20:13 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 51364-09 for ; Tue, 20 Jul 2004 08:20:08 +0000 (GMT) Received: from mpls-qmqp-02.inet.qwest.net (mpls-qmqp-02.inet.qwest.net [63.231.195.113]) by svr1.postgresql.org (Postfix) with SMTP id D06C6D1B16E for ; Tue, 20 Jul 2004 05:20:04 -0300 (ADT) Received: (qmail 75742 invoked by uid 0); 20 Jul 2004 07:08:48 -0000 Received: from mpls-pop-06.inet.qwest.net (63.231.195.6) by mpls-qmqp-02.inet.qwest.net with QMQP; 20 Jul 2004 07:08:48 -0000 Received: from 63-227-127-37.dnvr.qwest.net (HELO ?10.0.0.2?) (63.227.127.37) by mpls-pop-06.inet.qwest.net with SMTP; 20 Jul 2004 08:20:05 -0000 Date: Tue, 20 Jul 2004 02:20:56 -0600 Message-Id: <1090311656.709.14.camel@localhost.localdomain> From: "Scott Marlowe" To: bsimon@loxane.com Cc: pgsql-performance@postgresql.org Subject: Re: NAS, SAN or any alternate solution ? In-Reply-To: References: Content-Type: text/plain Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.1 tagged_above=0.0 required=5.0 tests=RCVD_IN_SORBS X-Spam-Level: X-Archive-Number: 200407/119 X-Sequence-Number: 7510 On Tue, 2004-07-20 at 01:52, bsimon@loxane.com wrote: > Hi all, > > I've been searching the list for a while but couldn't find any > up-to-date information relating to my problem. > We have a production server with postgresql on cygwin that currently > deels with about 200 Gigs of data (1 big IDE drive). We plan to move > to linux for some reasons I don't have to explain. > Our aim is also to be able to increase our storage capacity up to > approximately 1 or 2 terabytes and to speed up our production process. > As we are a small "microsoft addicted" company , we have some > difficulties to choose the best configuration that would best meet our > needs. > Our production process is based on transaction (mostly huge inserts) > and disk access is the main bottlle-neck. > > Our main concern is hardware related : > > Would NAS or SAN be good solutions ? (I've read that NAS uses NFS > which could slow down the transfer rate ??) > Has anyone ever tried one of these with postgresql ? Your best bet would likely be a large external RAID system with lots o cache. Next would be a fast internal RAID card like the LSI Megaraid cards, with lots of drives and batter backed cache. Next would be a SAN, but be careful, there may be issues with some cards and their drivers under linux, research them well before deciding. NFS is right out if you want good performance AND reliability. The cheapest solution that is likely to meet your needs would be the internal RAID card with battery backed cache.