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
Good RAID controller with lots of memory and BBU.
Any hints, recommendations would be greatly appreciated.
pgsql-performance by date
|Next:||From: Claus Guttesen||Date: 2008-06-25 10:56:59|
|Subject: Re: Hardware suggestions for high performance 8.3|
|Previous:||From: Heikki Linnakangas||Date: 2008-06-25 10:11:02|
|Subject: Re: Postgresql update op is very very slow|