X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 50A399DD07C for ; Mon, 12 Dec 2005 12:25:11 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 61638-08 for ; Mon, 12 Dec 2005 12:25:08 -0400 (AST) 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 929C99DD072 for ; Mon, 12 Dec 2005 12:25:07 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id jBCGP571002697; Mon, 12 Dec 2005 11:25:05 -0500 (EST) To: jose fuenmayor cc: pgsql-admin@postgresql.org Subject: Re: separate WAL In-reply-to: <69f2062a0512120808gc25aa08tcc3e31ab52b12d50@mail.gmail.com> References: <69f2062a0512120808gc25aa08tcc3e31ab52b12d50@mail.gmail.com> Comments: In-reply-to jose fuenmayor message dated "Mon, 12 Dec 2005 12:08:55 -0400" Date: Mon, 12 Dec 2005 11:25:05 -0500 Message-ID: <2696.1134404705@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.141 required=5 tests=[AWL=-0.135, MAILTO_TO_SPAM_ADDR=0.276] X-Spam-Score: 0.141 X-Spam-Level: X-Archive-Number: 200512/95 X-Sequence-Number: 19815 jose fuenmayor writes: > How can I install pg_xlog (WAL) in another partition, i mean separate the > data directory from WAL, i have a single scsi disk with four partitions > /, /boot, /data(data for postgresql), /WAL(pg_xlog), i ve heard that by > doing this occurs a boost in postgreSQL performance, thanks in advance > anyone that helps me. If there's only one physical disk spindle, there is no performance value in spreading PG across multiple partitions on that disk --- in fact that will likely be a net loss, because it'll force larger seek distances between the different files the database has to access. The common recommendation is to put WAL on a separate *physical disk*. If you don't have multiple disks there's no advantage to be gained. (I have seen people put WAL on a separate logical partition anyway, because it insulates the WAL from possible out-of-disk-space conditions in the other partitions, which is a good thing because out-of-space is a PANIC condition for WAL but not for the main DB. But if you're doing it because you think you'll gain performance you are misguided.) regards, tom lane