| 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: | Whole Thread | Raw Message | 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 |