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 <ja...@poczta.srv.pl> 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 >
