Postgres Pro
Downloads
Home   >   mailing lists

Re: Help tuning a large table off disk and into RAM - Mailing list pgsql-general

From Alban Hertroys
Subject Re: Help tuning a large table off disk and into RAM
Date
Msg-id 46FA7E8C.40307@magproductions.nl
Whole thread Raw
In response to Help tuning a large table off disk and into RAM  ("James Williams" <james.wlms@googlemail.com>)
List pgsql-general
Tree view 
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@magproductions.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 //

pgsql-general by date:

Previous
From: Raymond O'Donnell
Date:
Subject: Re: Dumping from older version
Next
From: David Siebert
Date:
Subject: More on migragting the server.