Re: Handling large volumes of data

From: Andrew Sullivan <ajs(at)crankycanuck(dot)ca>
To: pgsql-admin(at)postgresql(dot)org
Cc: Johann Spies <jspies(at)sun(dot)ac(dot)za>
Subject: Re: Handling large volumes of data
Date: 2008-04-09 14:00:45
Message-ID: 20080409140045.GA14729@crankycanuck.ca
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:
> I have got 8x720G disks in a hardware raid 5 setup. It is a Dell 2950

Thow away your RAID 5. It's a loser for this. Raid 1+0 is what you need.

> server. I am using an XFS-filesystem. I am not certain about the

On another note, I've had abysmal experiences with xfs on linux. Like,
"Oops, everything's in lost+found now!" abysmal.

(Unfortunately, actually, in my experience Linux has only bad and worse
choices for database filesystems. Maybe they'll get it right with ext4.)

A

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Vyacheslav Kalinin 2008-04-09 14:21:32 Re: How do i get DDL of a Table from system catalog ?
Previous Message Potluri Srikanth 2008-04-09 13:50:44 How do i get DDL of a Table from system catalog ?