From: Sven Geisler <sgeisler@aeccom.com>
To: hubert depesz lubaczewski <depesz@gmail.com>
Cc: Pgsql-Performance <pgsql-performance@postgresql.org>
Subject: Re: how to partition disks
Date: Wed, 14 Jun 2006 13:41:31 +0200
Message-ID: <448FF5EB.8010808@aeccom.com> (raw)
In-Reply-To: <9e4684ce0606140421m1a71581dmaa7a9adb988aedc8@mail.gmail.com>
References: <9e4684ce0606140052m62552d41xa9364b9d4e266c97@mail.gmail.com>
<448FC843.1090205@aeccom.com>
<9e4684ce0606140421m1a71581dmaa7a9adb988aedc8@mail.gmail.com>
Hi Hupert,
hubert depesz lubaczewski schrieb:
> On 6/14/06, *Sven Geisler* <sgeisler@aeccom.com
> <mailto:sgeisler@aeccom.com>> wrote:
> You should configure your discs to RAID 10 volumes.
> You should set up a separate volume for WAL.
> A volume for an additional table space may also useful.
> In your case I would do 2 partitions:
> 1. RAID 10 with 8 discs for general data
>
>
> raid 10 is of course not questionable. but are you sure that it will
> work faster than for example:
> 2 discs (raid 1) for xlog
> 6 discs (raid 10) for tables
> 6 discs (raid 10) for indices?
>
This depends on your application. Do you have a lot of disc reads?
Anyhow, I would put the xlog always to a RAID 10 volume because most of
the I/O for update and inserts is going to the xlog.
4 discs xlog
6 discs tables
4 discs tables2
This should be better. You should distribute indices on separate spindle
stacks to share the I/O. But again this depends on your application and
your server. How are the indices used? How large is your file system
cache. What does PostgreSQL effectively read from disc.
Don't forget to tune your postgresql.conf:
<http://www.powerpostgresql.com/PerfList;
<http://www.powerpostgresql.com/Downloads/terabytes_osc2005.pdf;
Cheers
Sven.
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: sgeisler@aeccom.com, depesz@gmail.com
Subject: Re: how to partition disks
In-Reply-To: <448FF5EB.8010808@aeccom.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