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 A7F79564AB for ; Thu, 10 Mar 2005 07:41:03 +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 24056-04 for ; Thu, 10 Mar 2005 07:40:57 +0000 (GMT) Received: from mailgate3.nau.edu (mailgate3.nau.edu [134.114.96.145]) by svr1.postgresql.org (Postfix) with ESMTP id 8FA07564C6 for ; Thu, 10 Mar 2005 07:40:56 +0000 (GMT) Received: from CONVERSION-DAEMON.mailgate3.nau.edu by mailgate3.nau.edu (PMDF V6.2-X17 #30845) id <0ID400101LC8UE@mailgate3.nau.edu> for pgsql-performance@postgresql.org; Thu, 10 Mar 2005 00:40:57 -0700 (MST) Received: from k2.cet.nau.edu (net9-213.cet.nau.edu [134.114.9.213]) by mailgate3.nau.edu (PMDF V6.2-X17 #30845) with ESMTP id <0ID400BE6LC848@mailgate3.nau.edu> for pgsql-performance@postgresql.org; Thu, 10 Mar 2005 00:40:56 -0700 (MST) Date: Thu, 10 Mar 2005 00:44:44 -0700 From: Karim Nassar Subject: What's better: Raid 0 or disk for seperate pg_xlog To: pgsql-performance@postgresql.org Message-id: <1110440684.6368.163.camel@k2.cet.nau.edu> MIME-version: 1.0 X-Mailer: Evolution 2.0.2 Content-type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="=-yq9LhudNh8UnGe/lSGWF" 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: 200503/178 X-Sequence-Number: 10883 --=-yq9LhudNh8UnGe/lSGWF Content-Type: text/plain Content-Transfer-Encoding: quoted-printable =46rom rom http://www.powerpostgresql.com/PerfList/ "even in a two-disk server, you can put the transaction log onto the operating system disk and reap some benefits." Context: I have a two disk server that is about to become dedicated to postgresql (it's a sun v40z running gentoo linux). What's "theoretically better"?=20 1) OS and pg_xlog on one disk, rest of postgresql on the other? (if I understand the above correctly) 2) Everything striped Raid 0? 3) TIA, --=20 Karim Nassar Department of Computer Science Box 15600, College of Engineering and Natural Sciences Northern Arizona University, Flagstaff, Arizona 86011 Office: (928) 523-5868 -=3D- Mobile: (928) 699-9221 --=-yq9LhudNh8UnGe/lSGWF Content-Type: application/pgp-signature; name=signature.asc Content-Description: This is a digitally signed message part -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.6 (GNU/Linux) iD8DBQBCL/rsXcetVcVKInsRAth/AJ0TAeTEqMOOJWH+3DIIGAQUjWbmcACfbIUm K8/oDMqIdzu1d63v8zKOYL4= =UhKZ -----END PGP SIGNATURE----- --=-yq9LhudNh8UnGe/lSGWF--