> 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 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html