X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.192]) by svr1.postgresql.org (Postfix) with ESMTP id 0D138CC415 for ; Thu, 17 Jul 2003 02:57:17 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (svr4.postgresql.org [64.117.224.192]) (amavisd-new, port 10024) with ESMTP id 60016-07 for ; Thu, 17 Jul 2003 02:57:35 +0000 (GMT) Received: from v2.intertune.com (unknown [209.75.26.20]) by svr1.postgresql.org (Postfix) with ESMTP id EBC5CCADB5 for ; Wed, 16 Jul 2003 23:57:10 -0300 (ADT) Received: from home01 (66-75-1-38.san.rr.com [66.75.1.38]) (authenticated) by v2.intertune.com (8.11.6/8.11.6) with ESMTP id h6H3K3i17635 for ; Wed, 16 Jul 2003 20:20:03 -0700 Message-ID: <004b01c34c0f$256bfb80$0600a8c0@home01> From: "Balazs Wellisch" To: Subject: Hardware performance Date: Wed, 16 Jul 2003 19:57:22 -0700 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0048_01C34BD4.789C1230" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.6 tagged_above=0.0 required=5.0 tests=BAYES_30, HTML_20_30 X-Spam-Level: X-Archive-Number: 200307/239 X-Sequence-Number: 2532 This is a multi-part message in MIME format. ------=_NextPart_000_0048_01C34BD4.789C1230 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi all, first of all I'd like to thank everyone who responded to my earlier post. I= have a much better understanding of postgres performance tuning now. In ca= se anyone's interested we've decided to go with RH9 and PostgreSQL 7.3 and = we'll do the OS and DB tuning ourselves. (should be a good learning experie= nce) We are now getting ready to purchase the hardware that will be used to run = the database server. We're spending quite a bit of money on it because this= will eventually, if things go well within two months, become a production = server. We're getting all RH certified hardware from Dell. (Dell 2650) We're now stuck on the question of what type of RAID configuration to use f= or this server. RAID 5 offers the best fault tolerance but doesn't perform = all that well. RAID 10 offers much better performance, but no hot swap. Or = should we not use RAID at all. I know that ideally the log (WAL) files shou= ld reside on a separate disk from the rest of the DB. Should we use 4 separ= ate drives instead? One for the OS, one for data, one for WAL, one for swap= ? Or RAID 10 for everything plus 1 drive for WAL? Or RAID 5 for everything? We have the budget for 5 drives. Does anyone have any real world experience= with what hard drive configuration works best for postgres? This is going = to be a dedicated DB server. There are going to be a large number of transa= ctions being written to the database. (Information is logged from a separat= e app through ODBC to postgres) And there will be some moderately complex q= ueries run concurrently to present this information in the form of various = reports on the web. (The app server is a separate machine and will connect = to the DB through JDBC to create the HTML reports) Any thoughts, ideas, comments would be appreciated. Thank you, Balazs Wellisch Neu Solutions balazs@neusolutions.com ------=_NextPart_000_0048_01C34BD4.789C1230 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hi all,
 
first of all I'd like to thank everyone wh= o=20 responded to my earlier post. I have a much better understanding of postgre= s=20 performance tuning now. In case anyone's interested we've decided to go wit= h RH9=20 and PostgreSQL 7.3 and we'll do the OS and DB tuning ourselves. (should be = a=20 good learning experience)
 
We are now getting ready to purchase the h= ardware=20 that will be used to run the database server. We're spending quite a bit of= =20 money on it because this will eventually, if things go well within two= =20 months, become a production server. We're getting all RH certified hardware= from=20 Dell. (Dell 2650)
 
We're now stuck on the question of what ty= pe of=20 RAID configuration to use for this server. RAID 5 offers the best fault=20 tolerance but doesn't perform all that well. RAID 10 offers much better=20 performance, but no hot swap. Or should we not use RAID at all. I know that= =20 ideally the log (WAL) files should reside on a separate disk from the rest = of=20 the DB. Should we use 4 separate drives instead? One for the OS, one for da= ta,=20 one for WAL, one for swap? Or RAID 10 for everything plus 1 drive for WAL? = Or=20 RAID 5 for everything?
 
We have the budget for 5 drives. Does anyo= ne have=20 any real world experience with what hard drive configuration works best for= =20 postgres? This is going to be a dedicated DB server. There are going to be = a=20 large number of transactions being written to the database. (Information is= =20 logged from a separate app through ODBC to postgres) And there will be some= =20 moderately complex queries run concurrently to present this information&nbs= p;in=20 the form of various reports on the web. (The app server is a separate machi= ne=20 and will connect to the DB through JDBC to create the HTML reports)<= /DIV>
 
Any thoughts, ideas, comments would be=20 appreciated.
 
Thank you,
 
Balazs Wellisch
Neu Solutions
balazs@neusolutions.com<= /DIV>
 
------=_NextPart_000_0048_01C34BD4.789C1230--