Re: how to partition disks - Mailing list pgsql-performance

From Michael Stone
Subject Re: how to partition disks
Date
Msg-id 20060616112302.GE29023@mathom.us
Whole thread Raw
In response to Re: how to partition disks  (Sven Geisler <sgeisler@aeccom.com>)
List pgsql-performance
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

pgsql-performance by date:

Previous
From: "Mikael Carneholm"
Date:
Subject: Re: SAN performance mystery
Next
From: "Jonah H. Harris"
Date:
Subject: Re: Optimizer internals