From: Iñigo Martinez Lasala <imartinez@vectorsf.com>
To: Anj Adu <fotographs@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: more 10K disks or less 15K disks
Date: Wed, 28 Apr 2010 22:29:14 +0200
Message-ID: <1272486554.16259.73.camel@deimos> (raw)
In-Reply-To: <i2pf2fd819a1004281127sf91d988cua1d95d13d09dae09@mail.gmail.com>
References: <i2pf2fd819a1004281127sf91d988cua1d95d13d09dae09@mail.gmail.com>
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
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-admin@postgresql.org
Cc: imartinez@vectorsf.com, fotographs@gmail.com
Subject: Re: more 10K disks or less 15K disks
In-Reply-To: <1272486554.16259.73.camel@deimos>
* 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