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 332C153A41 for ; Fri, 1 Apr 2005 09:10:09 +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 21080-02 for ; Fri, 1 Apr 2005 08:10:05 +0000 (GMT) Received: from window.monsterlabs.com (window.monsterlabs.com [216.183.105.176]) by svr1.postgresql.org (Postfix) with SMTP id 44ACA53A11 for ; Fri, 1 Apr 2005 09:10:02 +0100 (BST) Received: (qmail 30492 invoked from network); 1 Apr 2005 08:10:00 -0000 Received: from c-66-30-13-6.hsd1.ma.comcast.net (HELO ?192.168.0.101?) (66.30.13.6) by 0 with SMTP; 1 Apr 2005 08:10:00 -0000 In-Reply-To: <424CAB5D.9020807@sfnet.cc> References: <42443863.4040302@sfnet.cc> <4244A90B.2030200@sfnet.cc> <42453273.2060509@turtle-entertainment.de> <200503261255.59007.josh@agliodbs.com> <42455DEC.2080301@sfnet.cc> <1112049794.23284.29.camel@localhost.localdomain> <424840AE.3050200@sfnet.cc> <1112107974.7903.28.camel@sixtyfour.internetstaff.com> <424CAB5D.9020807@sfnet.cc> Mime-Version: 1.0 (Apple Message framework v619.2) Content-Type: text/plain; charset=US-ASCII; format=flowed Message-Id: Content-Transfer-Encoding: 7bit Cc: pgsql-performance@postgresql.org From: Thomas F.O'Connell Subject: Re: Follow-Up: How to improve db performance with $7K? Date: Fri, 1 Apr 2005 03:09:50 -0500 To: Steve Poe X-Mailer: Apple Mail (2.619.2) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200504/3 X-Sequence-Number: 11400 I'd use two of your drives to create a mirrored partition where pg_xlog resides separate from the actual data. RAID 10 is probably appropriate for the remaining drives. Fortunately, you're not using Dell, so you don't have to worry about the Perc3/Di RAID controller, which is not so compatible with Linux... -tfo -- Thomas F. O'Connell Co-Founder, Information Architect Sitening, LLC http://www.sitening.com/ 110 30th Avenue North, Suite 6 Nashville, TN 37203-6320 615-260-0005 On Mar 31, 2005, at 9:01 PM, Steve Poe wrote: > Thanks for everyone's feedback on to best improve our Postgresql > database for the animal hospital. I re-read the PostgreSQL 8.0 > Performance Checklist just to keep focused. > > We purchased (2) 4 x 146GB 10,000rpm SCSI U320 SCA drive arrays > ($2600) and (1) Sun W2100z dual AMD64 workstation with 4GB RAM > ($2500). We did not need a rack-mount server, so I though Sun's > workstation would do fine. I'll double the RAM. Hopefully, this should > out-perform our dual 2.8 Xeon with 4GB of RAM. > > Now, we need to purchase a good U320 RAID card now. Any suggestions > for those which run well under Linux? > > These two drive arrays main purpose is for our database. For those > messed with drive arrays before, how would you slice-up the drive > array? Will database performance be effected how our RAID10 is > configured? Any suggestions? > > Thanks. > > Steve Poe