| From: | tom dyson <tom(at)torchbox(dot)com> |
|---|---|
| To: | <pgsql-general(at)postgresql(dot)org> |
| Cc: | Neal Todd <neal(at)torchbox(dot)com> |
| Subject: | optimum postgres server configuration |
| Date: | 2003-07-24 15:29:38 |
| Message-ID: | BB45B9F2.1083E%tom@torchbox.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
And does the list have any observations regarding Postgres performance on
different platforms? Our webservers run Linux (RedHat 8), but we're willing
to experiment with alternatives.
Many thanks
Tom
-----------------+
tom dyson
t: +44 (0)1608 811870
m: +44 (0)7958 752657
http://torchbox.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dennis Gearon | 2003-07-24 15:32:44 | Re: SAP DB: The unsung Open Source DB |
| Previous Message | scott.marlowe | 2003-07-24 15:12:20 | Re: Limited varchar, unlimited varchar, or text? |