Postgres Pro
Downloads
Home   >   mailing lists

Hardware suggestions for high performance 8.3 - Mailing list pgsql-performance

From Henrik
Subject Hardware suggestions for high performance 8.3
Date
Msg-id 2B6702BC-3513-407E-AAC2-7E04299CA237@mac.se
Whole thread Raw
Responses Re: Hardware suggestions for high performance 8.3  ("Claus Guttesen" <kometen@gmail.com>)
Re: Hardware suggestions for high performance 8.3  (Matthew Wakeling <matthew@flymine.org>)
Re: Hardware suggestions for high performance 8.3  (Greg Smith <gsmith@gregsmith.com>)
List pgsql-performance
Tree view 
Hi list,


We have a database with lots of small simultaneous writes and reads
(millions every day) and are looking at buying a good hardware for this.

What are your suggestions. What we are currently looking at is.

Dual Quad Core Intel
8 - 12 GB RAM

10 disks total.

4 x 146 GB SAS disk in RAID 1+0 for database
6 x 750 GB SATA disks in RAID 1+0 or RAID 5 for OS and transactions
logs.

Good RAID controller with lots of memory and BBU.

Any hints, recommendations would be greatly appreciated.

Cheers,
Henke

pgsql-performance by date:

Previous
From: "Heikki Linnakangas"
Date:
Subject: Re: Postgresql update op is very very slow
Next
From: "Claus Guttesen"
Date:
Subject: Re: Hardware suggestions for high performance 8.3