CPU selection factors

[thayalan]

Hello,

a) Single Intel Xeon E5-2650 (8 Cores, 2.00 GHz, Cache = 20M, Bus Speed = 8GT/s)
b) Single Intel Xeon E5-2690 (8 Cores, 2.90 GHz, Cache = 20M, Bus Speed = 8GT/s)
c) Dual Intel Xeon E5-2620 (12 Cores, 2.00 GHz, Cache = 15M, Bus Speed = 7.2GT/s)

c) has a 50% increase in number of Cores compared to b).
b) has a 33% increase in Cache size and 11% increase in Bus speed compared to c).
Which among them in general will give a better performance than the other?
Which is more reliable?

b) has an increase in frequency of about 33% compared to that of a) and c).
Is there an increase in performance in general for b) when compared to that of c) ?

Best Regards
Thayalan

 

[basroil]

FOR WHAT PURPOSE?

When talking about server grade chips you need to give a reason for using them.

 

[thayalan]

FOR WHAT PURPOSE?

When talking about server grade chips you need to give a reason for using them.

The server is to be used for a postgresql database v9.5 running on Centos 7 64-bit. Current database size is 6GB but it will grow over time.

 

[basroil]

The server is to be used for a postgresql database v9.5 running on Centos 7 64-bit. Current database size is 6GB but it will grow over time.

You're better off asking a professional (HP, Dell, etc), since you won't be building it yourself.

In general though, more cores means more concurrent requests (assuming your database is in memory or your file system is fast enough), and faster cores means each request is completed faster. Max iops will depend a lot on what those requests are and your bandwidth out of the server though, so you very well could be I/O limited in some cases. There's just too many variables for a DB system, if it was just compute oriented it would be quite easy to suggest one over the other, but DBs are fairly sensitive to just about everything. Hence my suggestion is that you consult with a proper small business consultant at the company you are purchasing from (or better yet, multiple companies)