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 CE947329CF8 for ; Wed, 22 Sep 2004 21:53:11 +0100 (BST) 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 29120-04 for ; Wed, 22 Sep 2004 20:53:04 +0000 (GMT) Received: from tht.net (vista.tht.net [216.126.88.2]) by svr1.postgresql.org (Postfix) with ESMTP id D3E79329C6B for ; Wed, 22 Sep 2004 21:53:04 +0100 (BST) Received: from [134.22.69.205] (dyn-69-205.tor.dsl.tht.net [134.22.69.205]) by tht.net (Postfix) with ESMTP id 612B276A67; Wed, 22 Sep 2004 16:53:02 -0400 (EDT) Subject: Re: NAS, SAN or any alternate solution ? From: Rod Taylor To: Andrew Hammond Cc: Postgresql Performance In-Reply-To: <4151E1E7.2000009@ca.afilias.info> References: <1090344321.7056.105.camel@jester> <4151E1E7.2000009@ca.afilias.info> Content-Type: text/plain Message-Id: <1095886379.24440.56.camel@jester> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 Date: Wed, 22 Sep 2004 16:52:59 -0400 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200409/226 X-Sequence-Number: 8354 > Rod Taylor wrote: > | I've used both a NetApp and Hitachi based SANs with PostgreSQL. Both > | work as well as expected, but do require some tweeking as they normally > | are not optimized for the datablock size that PostgreSQL likes to deal > | with (8k by default) -- this can make as much as a 50% difference in > | performance levels. > I'm also not entirely sure how to make the datablocks line up with the > filesystem blocks. Any suggestions on this would be greatly appreciated. We just played with Veritas settings while running pg_bench on a 200GB database. I no longer have access to the NetApp, but the settings for the Hitachi are below. In tunefstab we have: read_pref_io=8192,read_nstream=4,write_pref_io=8192,write_nstream=2 In fstab it's: defaults,mincache=tmpcache,noatime If you have better settings, please shoot them over so we can try them out. Perhaps even get someone over there to write a new SAN section in the Tuning Chapter.