| From: | nolan(at)celery(dot)tssi(dot)com |
|---|---|
| To: | tom(at)torchbox(dot)com (tom dyson) |
| Cc: | pgsql-general(at)postgresql(dot)org, neal(at)torchbox(dot)com (Neal Todd) |
| Subject: | Re: optimum postgres server configuration |
| Date: | 2003-07-24 15:39:46 |
| Message-ID: | 20030724153946.11144.qmail@celery.tssi.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dennis Gearon | 2003-07-24 15:41:09 | Re: psql -e |
| Previous Message | Dennis Gearon | 2003-07-24 15:39:17 | Re: SAP DB: The unsung Open Source DB |