The answer, as always, is "it depends."
Can you give us an overview of your setup? The appropriate setup for small numbers of long-running analytical queries (typically faster CPUs) will be different than a setup for handling numerous simultaneous connections (typically more cores).
But CPU is often not the limiting factor. With a better understanding of your needs, people here can offer suggestions for memory, storage, pooling, network, etc.
Cheers,
Steve
On Tue, May 23, 2017 at 11:29 AM, Jarek <jarek@xxxxxxxxxxxxx> wrote:
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
