Re: more 10K disks or less 15K disks - Mailing list pgsql-admin

From Anj Adu
Subject Re: more 10K disks or less 15K disks
Date
Msg-id l2kf2fd819a1004281418o89f3c7bci66f21cfd7397f1f2@mail.gmail.com
Whole thread Raw
In response to Re: more 10K disks or less 15K disks  (Iñigo Martinez Lasala <imartinez@vectorsf.com>)
Responses Re: more 10K disks or less 15K disks
List pgsql-admin
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ñigo 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
>
>
>

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Error in PostgreSQL log
Next
From: Scott Marlowe
Date:
Subject: Re: more 10K disks or less 15K disks