From: Scott Marlowe <scott.marlowe@gmail.com>
To: Lionel <lionel@art-informatique.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Hardware HD choice...
Date: Thu, 23 Oct 2008 11:16:44 -0600
Message-ID: <dcc563d10810231016x2b66b7b8i5f6e7d2fb0ea0b6f@mail.gmail.com> (raw)
In-Reply-To: <dcc563d10810230938n4672582bo2ec8b989f41c5430@mail.gmail.com>
References: <gdq44g$f4o$1@news.hub.org>
<dcc563d10810230938n4672582bo2ec8b989f41c5430@mail.gmail.com>
On Thu, Oct 23, 2008 at 10:38 AM, Scott Marlowe <scott.marlowe@gmail.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.
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-performance@postgresql.org
Cc: scott.marlowe@gmail.com, lionel@art-informatique.com
Subject: Re: Hardware HD choice...
In-Reply-To: <dcc563d10810231016x2b66b7b8i5f6e7d2fb0ea0b6f@mail.gmail.com>
* 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