What HW / OS is recommeded

From: Alex <alex(at)meerkatsoft(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: What HW / OS is recommeded
Date: 2004-12-16 13:12:05
Message-ID: 41C189A5.8010303@meerkatsoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,
we are planning to upgrade our servers but deciding on the right
configuration seems to be quite difficult.

As for the system. About 50 tables, 20M records and growing about
500k-1m per month.
The systems mostly loads data from files (perl batch jobs). And
generates client files. Jobs generally dont run at the same time, but
timely loading/delivery is very important. We also run tomcat with no
more than 5-10 concurrent users connecting. (mostly browsing data)

We are currently looking at Dell / HP
but the questions is

- how many processors (2 or 4)
- do we gain with 4 cpus if we probably never have a few users connected
- what processors are recommended Opteron / Xeon / Itanium
- how much memory ? 2GB ? 4GB ?
- Disks, i guess we go with Raid5, 15k SCSI
- what OS ? Suse / RHE3 / Fedora /
- Disk controller ?

Currently we run it on a Dell Blade, dual P3 1.4ghz with 1G memory
Adding 1GB memory did actually not bring much performance gains.

Does anyone have some first hand experience? Can anybody point me to
some resources ? Or recommend certain systems?
What kind of performance gain can be expected going from a P3 to a
higher end processor ?

Thanks for any suggestions

Alex

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alex 2004-12-16 13:36:59 Re: DB Slowing Down
Previous Message Richard Huxton 2004-12-16 13:05:56 Re: DB Slowing Down