On Mon, 2004-08-30 at 05:48, William Yu wrote:
> Francois Suter wrote:
> > I have received via the Advocacy questions about optimising a database
> > server using PostgreSQL. The people asking the questions are planning to
> > buy a new machine, solely dedicated to serving PostgreSQL. Being no
> > specialist of optimisation, could someone help?
SNIP
> > What other components should they bet strongly on: RAM, HD, network card?
>
> High read activity -- a ton of RAM. High write activity -- a kickass
> SCSI RAID-0/1 config.
Don't forget the battery backed cache on the controller...