Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 9F6309FB45F for ; Sat, 24 Feb 2007 23:58:58 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-new, port 10024) with ESMTP id 50478-03 for ; Sat, 24 Feb 2007 23:58:49 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id D92AD9FB479 for ; Sat, 24 Feb 2007 23:58:55 -0400 (AST) 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 l1P3wp5P002056; Sat, 24 Feb 2007 22:58:51 -0500 (EST) To: Carlos Moreno cc: pgsql-performance@postgresql.org Subject: Re: Two hard drives --- what to do with them? In-reply-to: <45E104DD.3080600@mochima.com> References: <45DF3B15.1070609@3times25.net> <200702231330.57014.josh@agliodbs.com> <45DF5DA9.90002@commandprompt.com> <45DF6154.5090205@3times25.net> <1d4e0c10702231425ke37a732y36e241902fe0aa55@mail.gmail.com> <45DF94BF.6050904@3times25.net> <45E0A500.1010707@commandprompt.com> <45E104DD.3080600@mochima.com> Comments: In-reply-to Carlos Moreno message dated "Sat, 24 Feb 2007 22:39:09 -0500" Date: Sat, 24 Feb 2007 22:58:51 -0500 Message-ID: <2055.1172375931@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200702/275 X-Sequence-Number: 23329 Carlos Moreno writes: > The question is: does PostgreSQL have separate, independent areas that > require storage such that performance would be noticeably boosted if > the multiple storage operations could be done simultaneously? The standard advice in this area is to put pg_xlog on a separate spindle; although that probably is only important for update-intensive applications. You did not tell us anything about your application... regards, tom lane