pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Carlos Moreno <moreno_pg@mochima.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Two hard drives --- what to do with them?
Date: Sat, 24 Feb 2007 22:58:51 -0500
Message-ID: <2055.1172375931@sss.pgh.pa.us> (raw)
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>

Carlos Moreno <moreno_pg@mochima.com> 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



view thread (16+ messages)  latest in thread

Message-ID: <2055.1172375931@sss.pgh.pa.us>
Permalink:  ../2055.1172375931@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/2055.1172375931@sss.pgh.pa.us

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: tgl@sss.pgh.pa.us, moreno_pg@mochima.com
  Subject: Re: Two hard drives --- what to do with them?
  In-Reply-To: <2055.1172375931@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox