Hardware selection

From: psql-mail(at)freeuk(dot)com
To: pgsql-general(at)postgresql(dot)org
Subject: Hardware selection
Date: 2003-07-25 12:42:37
Message-ID: E19g1u9-000GUT-00@buckaroo.freeuk.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

As mentioned previously I have a large text database with upwards of
40GB of data and 8 million tuples.

The time has come to buy some real hardware for it.

Having read around the subject online I see the general idea is to get
as much memory and the fastest I/O possible.

The buget for the server is approx 20K GBP / 30K US$

The data will be stored on an external raid,
SCSI based 2.5TB with IDE disks. Configured as 1 large volume, RAID5. (
We already have this hardware)

Question 1 - whats the best raid configuration for this device?

Onto the server, I have currently priced up the following:
Dell Poweredge 6650
16GB RAM
Quad intel hyperthreaded arch
PERC3Q controller
36GB System HDD
approx 20K UKP

Question 2 - Comments and opinions on this as the postgresql server.
Any comments on better alternatives or modification to this system
would be very helpful!

Question 3 - what would be the best way to distribute tables/swap/
system disk space?

Hope I'm not asking too much...
Thanks !

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ron Johnson 2003-07-25 12:49:14 Re: Can I turn the case sensitive off
Previous Message Andrew Sullivan 2003-07-25 12:28:02 Re: Can I turn the case sensitive off