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

Re: Hardware HD choice...

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: Lionel <lionel(at)art-informatique(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Hardware HD choice...
Date: 2008-10-23 17:16:44
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-performance
On Thu, Oct 23, 2008 at 10:38 AM, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> wrote:
>> Any other better option that I could ask for ?
> Yes, more drives.  4 drives in a RAID10 is a good start.  If you could
> get 8 or 12 in one that's even better.

Note that for transactional databases SAS drives are usually
noticeably better, but for reporting databases, SATA drives are
generally fine, with 70-80% the sustained transfer rate at less than
half the cost per megabyte.  I'd recommend 8 SATA drives over 4 SAS
drives for a reporting database.  You'll spend about the same on twice
the number of drives but you'll get much more storage, which is often
useful when you need to work with large datasets.

In response to


pgsql-performance by date

Next:From: Collin KidderDate: 2008-10-23 17:25:47
Subject: Re: Annoying Reply-To
Previous:From: Alvaro HerreraDate: 2008-10-23 17:15:37
Subject: Re: Annoying Reply-To

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