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
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 |