Are you already on SSDs? That will be the dominant factor I think. Then memory.... After that, more cores are good for parallelism (especially with 9.6, although that requires solid memory support). Faster cores will be better if you expect complex calculations in memory, i.e., some analytics perhaps, but for your fairly straightforward write-throughput scenario, I think SSDs and memory will be king. LDH -----Original Message----- From: pgsql-performance-owner@xxxxxxxxxxxxxx [mailto:pgsql-performance-owner@xxxxxxxxxxxxxx] On Behalf Of Jarek Sent: Tuesday, May 23, 2017 14:30 To: pgsql-performance@xxxxxxxxxxxxxx Subject: More cores or higer frequency ? Hello! I've heavy loaded PostgreSQL server, which I want to upgrade, so it will handle more traffic. Can I estimate what is better: more cores or higher frequency ? I expect that pg_stat should give some tips, but don't know where to start... best regards Jarek -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
