From: Alex Turner <armtuk@gmail.com>
To: Carlos Benkendorf <carlosbenkendorf@yahoo.com.br>
Cc: pgsql-performance@postgresql.org
Subject: Re: Is RAID10 the best choice?
Date: Sun, 11 Dec 2005 23:45:51 -0500
Message-ID: <33c6269f0512112045u2dfe2393y59df6a89a7a5437a@mail.gmail.com> (raw)
In-Reply-To: <20051210113423.85996.qmail@web35514.mail.mud.yahoo.com>
References: <20051210113423.85996.qmail@web35514.mail.mud.yahoo.com>
Personaly I would split into two RAID 1s. One for pg_xlog, one for
the rest. This gives probably the best performance/reliability
combination.
Alex.
On 12/10/05, Carlos Benkendorf <carlosbenkendorf@yahoo.com.br> wrote:
> Hello,
>
> I would like to know which is the best configuration to use 4 scsi drives
> with a pg 8.1 server.
>
> Configuring them as a RAID10 set seems a good choice but now I´m figuring
> another configuration:
> SCSI drive 1: operational system
> SCSI drive 2: pg_xlog
> SCSI drive 3: data
> SCSI drive 4: index
>
> I know the difference between them when you analyze risks of loosing data
> but how about performance?
>
> What should be better?
>
> Obs.: Our system uses always an index for every access..
> (enable_seqscan(false))
>
> Thanks in advance!
>
> Benkendorf
>
> ________________________________
> Yahoo! doce lar. Faça do Yahoo! sua homepage.
>
>
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: armtuk@gmail.com, carlosbenkendorf@yahoo.com.br
Subject: Re: Is RAID10 the best choice?
In-Reply-To: <33c6269f0512112045u2dfe2393y59df6a89a7a5437a@mail.gmail.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