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
expectcomplex calculations in memory, i.e., some analytics perhaps, but for your fairly straightforward
write-throughputscenario, I think SSDs and memory will be king.
LDH
-----Original Message-----
From: pgsql-performance-owner@postgresql.org [mailto:pgsql-performance-owner@postgresql.org] On Behalf Of Jarek
Sent: Tuesday, May 23, 2017 14:30
To: pgsql-performance@postgresql.org
Subject: [PERFORM] 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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance