Re: optimum postgres server configuration - Mailing list pgsql-general

From nolan@celery.tssi.com
Subject Re: optimum postgres server configuration
Date
Msg-id 20030724153946.11144.qmail@celery.tssi.com
Whole thread Raw
In response to optimum postgres server configuration  (tom dyson <tom@torchbox.com>)
List 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

pgsql-general by date:

Previous
From: Dennis Gearon
Date:
Subject: Re: SAP DB: The unsung Open Source DB
Next
From: Dennis Gearon
Date:
Subject: Re: psql -e