Re: Best system for a data warehouse application

Option 1 is best if you will handle but a few connections to postgres
(~<=4), since the higher cpu clock will prevail in this scenario.
But if you expect having more than a few simultaneous connections go with
option 2 without a doubt.
Check how many simultaneous connections your DW system typically uses and
go from there. Although more cores would in general be the correct choice,
keep in mind that common DW in-database computations will greatly profit
from the extra cpu cycles of the 3.5 GHz cpu.

Cheers.

El 21 feb. 2017 2:39 PM, "John Scalia" <jayknowsunix(at)gmail(dot)com> escribió:

> Hi all,
>
> One of my system admins has approached me about replacing our production
> data warehouse system. I believe I know the answer, but would just like
> more opinions. He's giving me two options so far:
>
> 1) CPU = Intel e5-2637 3.5GHz 4 core with hyperthreading
>
> vs.
>
> 2) CPU = Intel e5-2650v4 2.2GHz 14 core with hyperthreading
>
> The rest of the specs are identical with 512Gb RAM and more than 2 Tb SSD
> drives. Our data warehouse is just shy of 2Tb now. I suspect the the first
> option would be more optimal as I don't think PostgreSQL can make effective
> use of a lot of processor cores. So fewer cores would be better optimized
> with the O/S. Can anyone weigh in on whether my assumptions are correct?
> --
> Jay
>