Best hardware/cost tradoff?

From: cluster <skrald(at)amossen(dot)dk>
To: pgsql-performance(at)postgresql(dot)org
Subject: Best hardware/cost tradoff?
Date: 2008-08-28 19:22:38
Message-ID: g96ttt$2l3m$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

I'm about to buy a combined web- and database server. When (if) the site
gets sufficiently popular, we will split the database out to a separate
server.

Our budget is limited, so how should we prioritize?

* We think about buying some HP Proliant server with at least 4GB ram
and at least a duo core processor. Possibly quad core. The OS will be
debian/Linux.

* Much of the database will fit in RAM so it is not *that* necessary to
prefer the more expensive SAS 10000 RPM drives to the cheaper 7500 RPM
SATA drives, is it? There will both be many read- and write queries and
a *lot* (!) of random reads.

* I think we will go for hardware-based RAID 1 with a good
battery-backed-up controller. I have read that software RAID perform
surprisingly good, but for a production site where hotplug replacement
of dead disks is required, is software RAID still worth it?

Anything else we should be aware of?

Thanks!

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Emi Lu 2008-08-28 19:31:04 update - which way quicker?
Previous Message david 2008-08-28 18:27:27 Re: select on 22 GB table causes "An I/O error occured while sending to the backend." exception