| From: | John Scalia <jayknowsunix(at)gmail(dot)com> |
|---|---|
| To: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Best system for a data warehouse application |
| Date: | 2017-02-21 17:38:22 |
| Message-ID: | CABzCKRAXP28nRq0w8_C_pDRbCJmM4fiE2zDZDTBJi=kJayCx0g@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Yuri Paes Leme | 2017-02-21 17:46:59 | Re: Best system for a data warehouse application |
| Previous Message | Keith | 2017-02-21 17:26:49 | Re: WAL archive space planning? |