Skip site navigation (1) Skip section navigation (2)

Hardware suggestions for high performance 8.3

From: Henrik <henke(at)mac(dot)se>
To: pgsql-performance(at)postgresql(dot)org
Subject: Hardware suggestions for high performance 8.3
Date: 2008-06-25 10:16:10
Message-ID: 2B6702BC-3513-407E-AAC2-7E04299CA237@mac.se (view raw or flat)
Thread:
Lists: pgsql-performance
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

Responses

pgsql-performance by date

Next:From: Claus GuttesenDate: 2008-06-25 10:56:59
Subject: Re: Hardware suggestions for high performance 8.3
Previous:From: Heikki LinnakangasDate: 2008-06-25 10:11:02
Subject: Re: Postgresql update op is very very slow

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group