Re: Handling large volumes of data - Mailing list pgsql-admin

From Tino Schwarze
Subject Re: Handling large volumes of data
Date
Msg-id 20080408120007.GC29990@easy2.in-chemnitz.de
Whole thread Raw
In response to Re: Handling large volumes of data  (Johann Spies <jspies@sun.ac.za>)
List pgsql-admin
On Tue, Apr 08, 2008 at 12:13:36PM +0200, Johann Spies wrote:

> > > This took about a week on a 2xCPU quadcore server with 8Gb RAM.
> >
> > This is not the most interesting thing here. What disk I/O subsystem do
> > you use? At least a hardware RAID controller with RAID 0 or 10 should
> > be used, with 10krpm or 15krpm drives. SAS preferred, as on SATA the
> > only quick disks are Western Digital Raptor (which aren't too bad,
> > btw).
>
> I have got 8x720G disks in a hardware raid 5 setup. It is a Dell 2950
> server.

I thought, the 2950 can only take 6 3.5" disks? Or are these 72GB 2.5"
ones? Then there are 15k SAS drives available.

> I am using an XFS-filesystem.  I am not certain about the
> speed of the hard disk, but we bought the fastest we could get.

Bye,

Tino.

--
„Es gibt keinen Weg zum Frieden. Der Frieden ist der Weg.” (Mahatma Gandhi)

www.craniosacralzentrum.de
www.forteego.de

pgsql-admin by date:

Previous
From: biggero@poczta.onet.pl
Date:
Subject: Hiding PG/SQL functions
Next
From: Johann Spies
Date:
Subject: Re: Handling large volumes of data