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