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

Re: raid10 hard disk choice

From: Matthew Wakeling <matthew(at)flymine(dot)org>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: raid10 hard disk choice
Date: 2009-05-21 12:59:20
Message-ID: alpine.DEB.2.00.0905211356440.4125@aragorn.flymine.org (view raw or flat)
Thread:
Lists: pgsql-performance
On Thu, 21 May 2009, Linos wrote:
> 	i have to buy a new server and in the budget i have (small) i have to 
> select one of this two options:
>
> -4 sas 146gb 15k rpm raid10.
> -8 sas 146gb 10k rpm raid10.

It depends what you are doing. I think in most situations, the second 
option is better, but there may be a few situations where the reverse is 
true.

Basically, the first option will only be faster if you are doing lots of 
seeking (small requests) in a single thread. As soon as you go 
multi-threaded or are looking at sequential scans, you're better off with 
more discs.

Matthew

-- 
 Experience is what allows you to recognise a mistake the second time you
 make it.

In response to

Responses

pgsql-performance by date

Next:From: Merlin MoncureDate: 2009-05-21 14:25:32
Subject: Re: raid10 hard disk choice
Previous:From: LinosDate: 2009-05-21 12:47:56
Subject: raid10 hard disk choice

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