| From: | Kenroy Bennett <bennettk9999(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Need advice on best system to choose |
| Date: | 2013-03-23 23:03:56 |
| Message-ID: | CALHXjLMtnCTL8eox0YaRPq=fENuyofH0QtEPTGUUqAm=+syC1g@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi,
I am trying to make a decision in choose between these following servers:
1) HP DL 380 G4
Intel Xeon 3.2GHZ 2MB cache
8 GB Ram
RAID -1 73GB SCSI 10K RPM (for OS)
Raid -1 300GB SCSI 10K RPM (data)
2) Sunfire X4150
Intel Xeon E5450 @ 3.0 GHZ 6MB cache
4GB RAM
RAID-1 73 GB SAS 10K RPM (for OS)
RAID -1 146 GB SAS 10K RPM
the database will be update on a hourly basis.
The data consist of mostly of floating point data on which complex
calculates will be performed on it. These calculations will be performed
and inserted into materialized views instead of on a perquerybasis. The
only addition calculation that will be performed during queries would be
aggregation calculations such as averges, sums,etc..
The current database size is currently 70GB, with largest table 16GB
I welcome your advice on choosing between these systems
Regards,
Kenroy
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jasen Betts | 2013-03-23 23:21:46 | Re: File Fragmentation |
| Previous Message | Jasen Betts | 2013-03-23 22:35:36 | Re: Can't terminate hung COPY |