X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id D5D1D11F6780 for ; Thu, 27 Apr 2006 10:10:14 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 13991-06 for ; Thu, 27 Apr 2006 10:09:58 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from noao.edu (noao.edu [140.252.1.54]) by postgresql.org (Postfix) with ESMTP id B27F911F65C6 for ; Thu, 27 Apr 2006 10:09:56 -0300 (ADT) X-TFF-CGPSA-Version: 1.4f1 X-TFF-CGPSA-Filter: Scanned Received: from weaver.tuc.noao.edu ([140.252.14.8] verified) by noao.edu (CommuniGate Pro SMTP 5.0.9) with ESMTPS id 25895456; Thu, 27 Apr 2006 06:09:51 -0700 Received: from weaver.tuc.noao.edu (localhost.localdomain [127.0.0.1]) by weaver.tuc.noao.edu (8.13.1/8.13.1) with ESMTP id k3RD9pAn021314; Thu, 27 Apr 2006 06:09:51 -0700 Received: (from swampler@localhost) by weaver.tuc.noao.edu (8.13.1/8.13.1/Submit) id k3RD9ot0021313; Thu, 27 Apr 2006 06:09:50 -0700 Date: Thu, 27 Apr 2006 06:09:50 -0700 From: Steve Wampler To: Ketema Harris Cc: Michael Stone , pgsql-performance@postgresql.org Subject: Re: Running on an NFS Mounted Directory Message-ID: <20060427130950.GA21200@weaver.tuc.noao.edu> Reply-To: swampler@noao.edu References: <20060427124455.GF31328@mathom.us> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.4.1i X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200604/638 X-Sequence-Number: 18722 On Thu, Apr 27, 2006 at 08:57:51AM -0400, Ketema Harris wrote: > OK. My thought process was that having non local storage as say a big raid > 5 san ( I am talking 5 TB with expansion capability up to 10 ) would allow > me to have redundancy, expandability, and hopefully still retain decent > performance from the db. I also would hopefully then not have to do > periodic backups from the db server to some other type of storage. Is this > not a good idea? How bad of a performance hit are we talking about? Also, > in regards to the commit data integrity, as far as the db is concerned once > the data is sent to the san or nas isn't it "written"? The storage may have > that write in cache, but from my reading and understanding of how these > various storage devices work that is how they keep up performance. I would > expect my bottleneck if any to be the actual Ethernet transfer to the > storage, and I am going to try and compensate for that with a full gigabit > backbone. Well, if you have to have both the best performance and remote attach storage, I think you'll find that a fibre-channel SAN is still the king of the hill. 4Gb FC switches are common now, though finding a 4Gb HBA for your computer might be a trick. 2Gb HBAs are everywhere in FC land. That's a premium price solution, however, and I don't know anything about how well PG would perform with a FC SAN. We use our SAN for bulk science data and leave the PGDB on a separate machine with local disk. -- Steve Wampler -- swampler@noao.edu The gods that smiled on your birth are now laughing out loud.