From: Bruno Wolff III <bruno@wolff.to>
To: Alvaro Nunes Melo <al_nunes@atua.com.br>
Cc: pgsql-performance@postgresql.org
Subject: Re: RAID Configuration Sugestion
Date: Tue, 30 Aug 2005 08:50:18 -0500
Message-ID: <20050830135018.GA27789@wolff.to> (raw)
In-Reply-To: <43145BE1.9050306@atua.com.br>
References: <431452FD.3090402@atua.com.br>
<20050830125808.GD22545@wolff.to>
<43145BE1.9050306@atua.com.br>
Please keep replies copied to the list so that others may contribute to
and learn from the discussion.
On Tue, Aug 30, 2005 at 10:15:13 -0300,
Alvaro Nunes Melo <al_nunes@atua.com.br> wrote:
> Hello Bruno,
>
> Bruno Wolff III wrote:
>
> >On Tue, Aug 30, 2005 at 09:37:17 -0300,
> > Alvaro Nunes Melo <al_nunes@atua.com.br> wrote:
> >
> >
> >>The server is a Dual Xeon 3.0 with 2 GB RAM and two SCSI disks. Our main
> >>doubt is what is the best configuration for the disks. We are thinking
> >>about use them in a RAID-0 array. Is this the best option? What do you
> >>suggest on partitioning? Separate partitions for the OS, data and pg_xlog?
> >
> Our main goal is performance speedup. Disk space might not be a problem.
> I've read a lot here about movig pg_xlog to different partitions, and
> we'll surely make tests to see what configuration might be better.
This isn't a very good mix of hardware for running postgres. Xeons have
some context switching issues for which you will probably see some
speed up in 8.1. (So if you aren't going into production for sevral
months you might want to be using 8.1beta.) Having only two disk drives
is also not a good idea.
With what you have you either want to use raid 0 and not worry too much
about how the disks are partitioned or use one disk for wal logging
and the other for other stuff. There are other people on the list who
can probably give you a better idea of which of these options is likely
to be better in your case. However, they may need to know more about
your raid controller. In particular how much battery backed memory does
it have and its model.
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: bruno@wolff.to, al_nunes@atua.com.br
Subject: Re: RAID Configuration Sugestion
In-Reply-To: <20050830135018.GA27789@wolff.to>
* 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