Skip site navigation (1) Skip section navigation (2)

Re: more 10K disks or less 15K disks

From: Anj Adu <fotographs(at)gmail(dot)com>
To: Iñigo Martinez Lasala <imartinez(at)vectorsf(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: more 10K disks or less 15K disks
Date: 2010-04-28 21:18:19
Message-ID: l2kf2fd819a1004281418o89f3c7bci66f21cfd7397f1f2@mail.gmail.com (view raw or flat)
Thread:
Lists: 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(at)vectorsf(dot)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(at)gmail(dot)com>
> To: pgsql-admin(at)postgresql(dot)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
>
>
>

In response to

Responses

pgsql-admin by date

Next:From: Scott MarloweDate: 2010-04-28 22:12:51
Subject: Re: more 10K disks or less 15K disks
Previous:From: Tom LaneDate: 2010-04-28 20:47:04
Subject: Re: Error in PostgreSQL log

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group