Need advice on best system to choose

Поиск
Список
Период
Сортировка
От Kenroy Bennett
Тема Need advice on best system to choose
Дата
Msg-id CALHXjLMtnCTL8eox0YaRPq=fENuyofH0QtEPTGUUqAm=+syC1g@mail.gmail.com
обсуждение исходный текст
Ответы Re: Need advice on best system to choose
Список 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 по дате отправления:

Предыдущее
От: Jasen Betts
Дата:
Сообщение: Re: Can't terminate hung COPY
Следующее
От: Jasen Betts
Дата:
Сообщение: Re: File Fragmentation