Re: Choosing a filesystem

From: Matthew Wakeling <matthew(at)flymine(dot)org>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Choosing a filesystem
Date: 2008-09-11 17:18:37
Message-ID: alpine.DEB.1.10.0809111814130.4454@aragorn.flymine.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Thu, 11 Sep 2008, Laszlo Nagy wrote:
> So the basic system will reside on a RAID 1 array, created from two SAS
> disks spinning at 15 000 rpm. I will buy 10 pieces of Seagate Barracuda
> 320GB SATA (ES 7200) disks for the rest.

That sounds good. Put RAID 1 on the pair, and RAID 1+0 on the rest. It'll
be pretty good. Put the OS and the WAL on the pair, and the database on
the large array.

However, one of the biggest things that will improve your performance
(especially in OLTP) is to use a proper RAID controller with a
battery-backed-up cache.

Matthew

--
X's book explains this very well, but, poor bloke, he did the Cambridge Maths
Tripos... -- Computer Science Lecturer

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Kenneth Marshall 2008-09-11 17:23:32 Re: Choosing a filesystem
Previous Message Andrew Sullivan 2008-09-11 17:07:26 Re: Choosing a filesystem