X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 182799FA372 for ; Fri, 19 May 2006 10:10:36 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 58622-09 for ; Fri, 19 May 2006 10:10:26 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id E72529F9AFD for ; Fri, 19 May 2006 10:10:26 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id k4JDAKou028305; Fri, 19 May 2006 09:10:21 -0400 (EDT) To: "Olivier Andreotti" cc: "Mikael Carneholm" , jean-paul@argudo.org, pgsql-performance@postgresql.org Subject: Re: Benchmarck PostgreSQL 8.1.4 MySQL 5.0.20 and Oracle 10g2 In-reply-to: References: <7F10D26ECFA1FB458B89C5B4B0D72C2B459FFB@sesrv12.wirelesscar.com> <13688.1147963700@sss.pgh.pa.us> Comments: In-reply-to "Olivier Andreotti" message dated "Fri, 19 May 2006 12:24:35 +0200" Date: Fri, 19 May 2006 09:10:20 -0400 Message-ID: <28304.1148044220@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/402 X-Sequence-Number: 19189 "Olivier Andreotti" writes: > Just a last question about the pg_xlog : i understand that the > directory must be moved but i have just 3 disks for the database : > disk 1 and 2 for the data, disk 3 for the indexes, where can i put the > pg_xlog ? If you have three disks then put the xlog on one of them and everything else on the other two. Separating out the indexes is way less important than getting xlog onto its very own spindle (at least for write-intensive cases). regards, tom lane