From: Michael Stone <mstone+postgres@mathom.us>
To: pgsql-performance@postgresql.org
Subject: Re: how to partition disks
Date: Fri, 16 Jun 2006 07:23:04 -0400
Message-ID: <20060616112302.GE29023@mathom.us> (raw)
In-Reply-To: <44901DF7.7010200@aeccom.com>
References: <20060614142344.13558.qmail@web31804.mail.mud.yahoo.com>
<44901DF7.7010200@aeccom.com>
On Wed, Jun 14, 2006 at 04:32:23PM +0200, Sven Geisler wrote:
>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.
Hmm. Bad example, IMO. In the case of reading indices you're doing
random IO and the heads will be jumping all over the place anyway. The
limiting factor there will be seeks/s, and you'll possibly get better
results with the larger array. (That case is fairly complicated to
analyze and depends very much on the data.) Where multiple arrays will be
faster is if you have a lot of sequential IO--in fact, a couple of cheap
disks can blow away a fairly expensive array for purely sequential
operations since each disk can handle >60MB/s of if it doesn't have to
seek, whereas multiple sequential streams on the big array will cause
each disk in the array to seek. (The array controller will try to hide
this with its cache; its cache size & software will determine how
successful it is at doing so.)
Mike Stone
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: mstone+postgres@mathom.us
Subject: Re: how to partition disks
In-Reply-To: <20060616112302.GE29023@mathom.us>
* 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