Re: Help tuning a large table off disk and into RAM

From: Alban Hertroys <a(dot)hertroys(at)magproductions(dot)nl>
To: James Williams <james(dot)wlms(at)googlemail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Help tuning a large table off disk and into RAM
Date: 2007-09-26 15:45:16
Message-ID: 46FA7E8C.40307@magproductions.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

James Williams wrote:
> The box has 4 x Opterons, 4Gb RAM & five 15k rpm disks, RAID 5. We
> wanted fast query/lookup. We know we can get fast disk IO.

RAID 5 is usually adviced against here. It's not particularly fast or
safe, IIRC. Try searching the ML archives for RAID 5 ;)

--
Alban Hertroys
alban(at)magproductions(dot)nl

magproductions b.v.

T: ++31(0)534346874
F: ++31(0)534346876
M:
I: www.magproductions.nl
A: Postbus 416
7500 AK Enschede

// Integrate Your World //

In response to

Browse pgsql-general by date

  From Date Subject
Next Message David Siebert 2007-09-26 15:47:24 More on migragting the server.
Previous Message Raymond O'Donnell 2007-09-26 15:37:00 Re: Dumping from older version