Re: optimum postgres server configuration

> We're about to buy a new server for dedicated Postgres serving. It'll be
> serving 4 - 10 databases (average dump size 20Gb) for various web
> applications. What is the list's advice on optimum configuration of hardware
> and software, given a smallish fixed budget (around $US 2000)? In
> particular, should we prioritise
>
> * Disk speed
> * Hardware RAID
> * Memory
> * Processor speed
> * Processor type
> * Multiple processors

Even with RAID you need to think about an external backup method and
budget for the hardware accordingly.  20GB x 10 databases is getting
up there for tape backup both in terms of capacity and in the time it
would take to do the backup.
--
Mike Nolan