hardware requirements under Redhat

From: kevin07(at)optonline(dot)net (kbd)
To: pgsql-general(at)postgresql(dot)org
Subject: hardware requirements under Redhat
Date: 2003-12-22 20:01:09
Message-ID: f5454a7d.0312221201.31f56554@posting.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello:

I know that hardware requirements are dependent upon many factors.
However I need a sanity check on this configuration.

First the purpose of the database.
- database will be used to support a risk analysis group in a small
financial firm.
- there will be daily "bulk" loads to the database
- as well as updates via GUIs (JSP or java programs)
- initial size of the database will be 5Gig, could grow to 20 Gig quickly
- database will support daily batch reports and adhoc quieies/reports
- database is being designed with normalization and referential integrity
in mind. Yes, we are going to think before we build.
- surrogate key will be used on the tables to reduce key size.
it is expected that this will reduce the size of primary
and foreign keys.

I am considering a generic box with a single 2 - 2.6 Gig processor.
2 Gig of RAM and mirrored 200 Gig drives.

Does this config cover the above requirements very well.
Does anybody know if RedHat 9 or Fedora can address 2 Gig
of RAM out of the box?

many thanks

kd

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2003-12-22 20:45:46 Re: hardware requirements under Redhat
Previous Message Robert Treat 2003-12-22 19:38:48 Re: Groff and Weinberg SQL Complete Reference - Sample