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 645FE329E4C for ; Thu, 23 Sep 2004 16:39:40 +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 66043-09 for ; Thu, 23 Sep 2004 15:39:38 +0000 (GMT) Received: from web41110.mail.yahoo.com (web41110.mail.yahoo.com [66.218.93.26]) by svr1.postgresql.org (Postfix) with SMTP id 128A8329E01 for ; Thu, 23 Sep 2004 16:39:36 +0100 (BST) Message-ID: <20040923153931.34861.qmail@web41110.mail.yahoo.com> Received: from [61.25.53.100] by web41110.mail.yahoo.com via HTTP; Thu, 23 Sep 2004 08:39:31 PDT Date: Thu, 23 Sep 2004 08:39:31 -0700 (PDT) From: Mr Pink Subject: Re: SAN performance To: Anjan Dave , pgsql-performance@postgresql.org In-Reply-To: <4BAFBB6B9CC46F41B2AD7D9F4BBAF785018B4049@vt-pe2550-001.vantage.vantage.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii 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/239 X-Sequence-Number: 8367 Hi, I expect you mean RAID 1/0 or 1+0 since the CX300 didn't support RAID 10 last time I looked. Whether you are using a SAN or not, you should consider putting the WAL files (pg_xlog folder) on seperate diskes from the DB. Since the log files are mostly written to, not read from you could just use RAID 1. It's a pity pg doesn't have a way to use a cluster of servers to get the most out of your expensive SAN. I read a comment earlier about setting block sizes to 8k to math pg's block size. Seems to make sense, you should check it out. Have fun, Mr Pink --- Anjan Dave wrote: > Hello, > > > > I'll be moving a DB from internal RAID-10 SCSI storage to an EMC CX300 > FC RAID-10 LUN, bound to the host. I've setup a test host machine and a > test LUN. The /var/lib/pgsql/data folder is sym-linked to a partition on > the LUN. > > > > Other than the shared_buffers, effective cache size, and sort memory, I > am not sure if I need to change any other parameters in the > postgresql.conf file for getting maximum performance from the EMC box. > > > > Is there a general guideline for setting up postgres database and the > tunable parameters on a SAN, especially for EMC? > > > > Appreciate any help, > > > > Thanks, > Anjan > > __________________________________ Do you Yahoo!? New and Improved Yahoo! Mail - 100MB free storage! http://promotions.yahoo.com/new_mail