Need advice on best system to choose - Mailing list pgsql-general

From Kenroy Bennett
Subject Need advice on best system to choose
Date
Msg-id CALHXjLMtnCTL8eox0YaRPq=fENuyofH0QtEPTGUUqAm=+syC1g@mail.gmail.com
Whole thread Raw
Responses Re: Need advice on best system to choose
List 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




     

pgsql-general by date:

Previous
From: Jasen Betts
Date:
Subject: Re: Can't terminate hung COPY
Next
From: Jasen Betts
Date:
Subject: Re: File Fragmentation