DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:in-reply-to:references:date:message-id:subject:from:to
	:cc:content-type:content-transfer-encoding;
	b=Ou4ovxhfk9g9253PCp3oLxOsNKz38MZph4m8l6f4lD3Q6QaCPCBy0p/TOY9J7vSE3p
	mJy1o8CN3f2qcATWJpEMikIciY69wVxEYCyqI3bytYv00OKGSkxNLHFspWjunZuDpkIv
	/9ovZ8SgQzxk9OcILCBb+2MjVEDFTnkEFXFV0=
MIME-Version: 1.0
In-Reply-To: <1272486554.16259.73.camel@deimos>
References: <i2pf2fd819a1004281127sf91d988cua1d95d13d09dae09@mail.gmail.com>
	<1272486554.16259.73.camel@deimos>
Date: Wed, 28 Apr 2010 14:18:19 -0700
Message-ID: <l2kf2fd819a1004281418o89f3c7bci66f21cfd7397f1f2@mail.gmail.com>
Subject: Re: more 10K disks or less 15K disks
From: Anj Adu <fotographs@gmail.com>
To: =?ISO-8859-1?Q?I=F1igo_Martinez_Lasala?= <imartinez@vectorsf.com>
Cc: pgsql-admin@postgresql.org
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Thank you all for the comments

We have not benchmarked the new hardware yet..however..we do have
existing hardware that deals with very high volumes and handle pretty
well (Dell 2950 Intel 5430 8-cores with 6x450G 15K disks and 32G RAM -
Perc 6iRaid controllers) with minimal IO wait . there are ususally
about10-15 threads running at peak time with an average of 4-10
threads overall.

We are looking at high density boxes due to increasing storage requirements=
.

Sriram


On Wed, Apr 28, 2010 at 1:29 PM, I=F1igo Martinez Lasala
<imartinez@vectorsf.com> wrote:
> Supposing a 50% performance increase disk-by-disk with 15.000rpm vs
> 10.000rpm you would get better performance (100%) by doubling number of
> disks versus using 15K rpm disk (50%).
> However, you have to check other parameters, for example, if your RAID
> controller can deal with such a high bandwidth or the disk cache size.
> Do you have benchmarks about these hard disk models ?
>
> How about using SSD? ;-)
>
> -----Original Message-----
> From: Anj Adu <fotographs@gmail.com>
> To: pgsql-admin@postgresql.org
> Subject: [ADMIN] more 10K disks or less 15K disks
> Date: Wed, 28 Apr 2010 11:27:26 -0700
>
> I am faced with a  hardware choice for a postgres data warehouse
> (extremely high volume inserts..over 200 million records a day) with a
> total storage of either
>
> 12 x 600G disks (15K)  (the new Dell Poweredge C server)
>
> or
>
> 24 x 600G  (10K disks)
>
> ALL direct attached storage.
>
> I am leaning toward the 24 disks as I expect the higher number of
> disks to provide overall better performance under high loads
>
> Does anyone have any experience with a mixed 10K / 15K DAS storage
> that you can share.
>
> Thank you
>
> Sriram
>
>
>