From: Richard Huxton <dev@archonet.com>
To: Karim Nassar <Karim.Nassar@acm.org>
Cc: John A Meinel <john@arbash-meinel.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: What's better: Raid 0 or disk for seperate pg_xlog
Date: Fri, 11 Mar 2005 08:05:57 +0000
Message-ID: <42315165.1050202@archonet.com> (raw)
In-Reply-To: <1110484232.9252.211.camel@k2.cet.nau.edu>
References: <1110440684.6368.163.camel@k2.cet.nau.edu>
<4230673B.3020400@arbash-meinel.com>
<1110484232.9252.211.camel@k2.cet.nau.edu>
Karim Nassar wrote:
> Thanks to all for the tips.
>
> On Thu, 2005-03-10 at 09:26 -0600, John A Meinel wrote:
>
>>How critical is your data? How update heavy versus read heavy, etc are you?
>
>
> Large, relatively infrequent uploads, with frequent reads. The
> application is a web front-end to scientific research data. The
> scientists have their own copy of the data, so if something went really
> bad, we could probably get them to upload again.
If you have very few updates and your reads aren't mostly from RAM you
could be better off with simply mirroring (assuming that gains you read
bandwidth). Failing that, use the tablespace feature to balance your
read load as far as you can.
--
Richard Huxton
Archonet Ltd
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: dev@archonet.com, Karim.Nassar@acm.org, john@arbash-meinel.com
Subject: Re: What's better: Raid 0 or disk for seperate pg_xlog
In-Reply-To: <42315165.1050202@archonet.com>
* 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