Re: Handling large volumes of data

From: Tino Schwarze <postgresql(at)tisc(dot)de>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Handling large volumes of data
Date: 2008-04-08 12:00:07
Message-ID: 20080408120007.GC29990@easy2.in-chemnitz.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Johann Spies 2008-04-08 12:16:03 Re: Handling large volumes of data
Previous Message biggero 2008-04-08 10:25:03 Hiding PG/SQL functions