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 3C7F63A5855 for ; Tue, 25 Jan 2005 20:06:45 +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 14050-09 for ; Tue, 25 Jan 2005 20:06:41 +0000 (GMT) Received: from mail.tecarta.com (66.238.115.135.ptr.us.xo.net [66.238.115.135]) by svr1.postgresql.org (Postfix) with ESMTP id 012903A5792 for ; Tue, 25 Jan 2005 20:06:34 +0000 (GMT) Received: from mail pickup service by mail.tecarta.com with Microsoft SMTPSVC; Tue, 25 Jan 2005 12:09:08 -0800 Received: from mail.tecarta.com ([192.168.160.2]) by mail.tecarta.com with Microsoft SMTPSVC(6.0.3790.0); Tue, 25 Jan 2005 12:09:05 -0800 Received: from barracuda.tecarta.com ([192.168.160.200]) by mail.tecarta.com (SAVSMTP 3.1.0.29) with SMTP id M2005012512090430138 for ; Tue, 25 Jan 2005 12:09:04 -0800 X-ASG-Debug-ID: 1106683590-13699-23-0 X-Barracuda-URL: http://192.168.160.200:8000/cgi-bin/mark.cgi Received: from mail1 (mail1.hq.corp [192.168.160.5]) by barracuda.tecarta.com (Spam Firewall) with SMTP id E1CAA201428B for ; Tue, 25 Jan 2005 12:06:30 -0800 (PST) Received: from [192.168.0.13] ([63.206.203.145]) by mail.tecarta.com with Microsoft SMTPSVC(6.0.3790.0); Tue, 25 Jan 2005 12:08:59 -0800 Message-ID: <41F63424.1060904@sfnet.cc> Date: Tue, 25 Jan 2005 11:57:24 +0000 From: Steve Poe User-Agent: Mozilla Thunderbird 1.0 (X11/20041228) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-performance@postgresql.org X-ASG-Orig-Subj: Ideal disk setup for Postgresql 7.4? Subject: Ideal disk setup for Postgresql 7.4? Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-OriginalArrivalTime: 25 Jan 2005 20:08:59.0139 (UTC) FILETIME=[B4BEB530:01C50319] X-Virus-Scanned: by Barracuda Spam Firewall at tecarta.com X-Barracuda-Spam-Score: -0.58 X-Barracuda-Spam-Status: No, SCORE=-0.58 using global scores of TAG_LEVEL=4.0 QUARANTINE_LEVEL=1000.0 KILL_LEVEL=7.0 tests=BAYES_20, DATE_IN_PAST_06_12 X-Barracuda-Spam-Report: Code version 2.64, rules version 2.1.951 Rule breakdown below pts rule name description ---- ---------------------- ------------------------------------------- -1.43 BAYES_20 BODY: Bayesian spam probability is 20 to 30% [score: 0.2996] 0.85 DATE_IN_PAST_06_12 Date: is 6 to 12 hours before Received: date X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.276 tagged_above=0 required=5 tests=AWL, DATE_IN_PAST_06_12, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200501/484 X-Sequence-Number: 10174 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. They're currently on a two-disk Adaptec RAID1 with Postgresql 7.4.2. The drive array is a 7-disk fibre channel on a Qlogic 2100 controller. I am currently testing RAID5 (sw). 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) additional info: On average, 30-35 vets/doctors are connecting to the database at any time from 7am - 7pm. The database is very active for the small company. Server Info: Centos 3.3 (RHEL 3.x equivelent) 4GB RAM Adaptec 2100S RAID Qlogic QLA2100 Fibre Any feedback/suggestions are greatly appreciated. Thanks. Steve Poe