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 CD30455683 for ; Thu, 10 Mar 2005 16:41:44 +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 80638-10 for ; Thu, 10 Mar 2005 16:41:42 +0000 (GMT) Received: from relay.icomedias.com (office.icomedias.com [62.99.232.80]) by svr1.postgresql.org (Postfix) with ESMTP id CE5A85636F for ; Thu, 10 Mar 2005 16:41:39 +0000 (GMT) Received: from loki.icomedias.com ([10.192.17.128]) by relay.icomedias.com (8.13.1/8.13.0) with ESMTP id j2AGfTlV004941; Thu, 10 Mar 2005 17:41:29 +0100 From: Mario Weilguni To: pgsql-performance@postgresql.org Subject: Re: What's better: Raid 0 or disk for seperate pg_xlog Date: Thu, 10 Mar 2005 17:41:28 +0100 User-Agent: KMail/1.8 Cc: Karim Nassar References: <1110440684.6368.163.camel@k2.cet.nau.edu> In-Reply-To: <1110440684.6368.163.camel@k2.cet.nau.edu> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Message-Id: <200503101741.28407.mweilguni@sime.com> X-Scanned-By: MIMEDefang 2.43 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=2.159 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_BOGUSMX, DNS_FROM_RFC_POST X-Spam-Level: ** X-Archive-Number: 200503/181 X-Sequence-Number: 10886 Am Donnerstag, 10. M=E4rz 2005 08:44 schrieb Karim Nassar: > From 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"? > > 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) Because of hard disk seeking times, a separate disk for WAL will be a lot=20 better. regards