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 6B6073A5915 for ; Wed, 26 Jan 2005 03:03:57 +0000 (GMT) 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 50230-09 for ; Wed, 26 Jan 2005 03:03:51 +0000 (GMT) Received: from davinci.ethosmedia.com (server227.ethosmedia.com [209.128.84.227]) by svr1.postgresql.org (Postfix) with ESMTP id C7C1B3A5886 for ; Wed, 26 Jan 2005 03:03:54 +0000 (GMT) X-EthosMedia-Virus-Scanned: no infections found Received: from [63.195.55.98] (account josh@agliodbs.com HELO spooky) by davinci.ethosmedia.com (CommuniGate Pro SMTP 4.1.8) with ESMTP id 6951196; Tue, 25 Jan 2005 19:05:37 -0800 From: Josh Berkus Organization: Aglio Database Solutions To: pgsql-performance@postgresql.org Subject: Re: Ideal disk setup for Postgresql 7.4? Date: Tue, 25 Jan 2005 19:03:09 -0800 User-Agent: KMail/1.6.2 Cc: Steve Poe References: <41F63424.1060904@sfnet.cc> In-Reply-To: <41F63424.1060904@sfnet.cc> MIME-Version: 1.0 Content-Disposition: inline Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Message-Id: <200501251903.09734.josh@agliodbs.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.014 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200501/489 X-Sequence-Number: 10179 Steve, > I help manage an animal hospital of 100-employees Linux servers. I am > new to database setup and tuning, I was hoping I could get some > direction on a setting up drive array we're considering moving our > database to. Check what I have to say at http://www.powerpostgresql.com/PerfList > They're currently on a two-disk Adaptec RAID1 with Postgresql 7.4.2. And you've not upgraded to 7.4.6 because .... ? > The drive array is a 7-disk fibre channel on a Qlogic 2100 controller. I > am currently testing RAID5 (sw). In general, RAID 5 is not so great for databases. See the article for more. > The main reason of moving to a drive array is the high level of context > switches we get during the day (>30K for 20 mins per hour). The OS and > database exist on the same disk but seperate parition (which probably > makes little difference) Unfortunately, the context switches are probably due to a known issue in PostgreSQL, and changing the drive array won't help this issue (it may help other issues though). Search the archives of this list, and pgsql-hackers, for "Context Switch Bug". For the CS bug, the only workaround right now is to avoid the query structures that trigger it. > Server Info: > Centos 3.3 (RHEL 3.x equivelent) > 4GB RAM > Adaptec 2100S RAID > Qlogic QLA2100 Fibre CPU? -- Josh Berkus Aglio Database Solutions San Francisco