From: Sven Geisler <sgeisler@aeccom.com>
To: Richard Broersma Jr <rabroersma@yahoo.com>
Cc: Pgsql-Performance <pgsql-performance@postgresql.org>
Subject: Re: how to partition disks
Date: Wed, 14 Jun 2006 16:32:23 +0200
Message-ID: <44901DF7.7010200@aeccom.com> (raw)
In-Reply-To: <20060614142344.13558.qmail@web31804.mail.mud.yahoo.com>
References: <20060614142344.13558.qmail@web31804.mail.mud.yahoo.com>
Hi Richard,
Richard Broersma Jr schrieb:
>> 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
>
> I have a question in regards to I/O bandwidths of various raid configuration. Primary, does the
> above suggested raid partitions imply that multiple (smaller) disk arrays have a potential for
> more I/O bandwidth than a larger raid 10 array?
Yes.
Because the disc arms didn't need to reposition that much as there would
o with one large volume.
For example, You run two queries with two clients and each queries needs
to read some indices from disk. In this case it more efficient to read
from different volumes than to read from one large volume where the disc
arms has to jump.
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, rabroersma@yahoo.com
Subject: Re: how to partition disks
In-Reply-To: <44901DF7.7010200@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