From: Johann Spies <jspies@sun.ac.za>
To: pgsql-admin@postgresql.org
Subject: Re: Handling large volumes of data
Date: Tue, 8 Apr 2008 12:13:36 +0200
Message-ID: <20080408101336.GJ13409@sun.ac.za> (raw)
In-Reply-To: <200804081201.15175@zmi.at>
References: <20080408094233.GG13409@sun.ac.za>
<200804081201.15175@zmi.at>
On Tue, Apr 08, 2008 at 12:01:14PM +0200, Michael Monnerie wrote:
> On Dienstag, 8. April 2008 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 am using an XFS-filesystem. I am not certain about the
speed of the hard disk, but we bought the fastest we could get.
Regards
Johann
--
Johann Spies Telefoon: 021-808 4036
Informasietegnologie, Universiteit van Stellenbosch
"Be careful for nothing; but in every thing by prayer
and supplication with thanksgiving let your requests
be made known unto God. And the peace of God, which
passeth all understanding, shall keep your hearts
hearts and minds through Christ Jesus."
Philippians 4:6,7
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-admin@postgresql.org
Cc: jspies@sun.ac.za
Subject: Re: Handling large volumes of data
In-Reply-To: <20080408101336.GJ13409@sun.ac.za>
* 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