Re: [PERFORM] More cores or higer frequency ?

Cheers, > Steve > > > > On Tue, May 23, 2017 at 11:29 AM, Jarek wrote: > Hello! > > I've heavy loaded PostgreSQL server, which I want to upgrade, > so it will > handle more traffic. Can I estimate what is bett

[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-p

Re: [PERFORM] Big number of connections

ow many users do you have and what kind of problems we may expect. Is there any risk, that huge number of roles will slowdown overall performance ? best regards Jarek -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://ww

[PERFORM] Big number of connections

will degrade performance ? I'll be happy to hear any remarks and suggestions related to design, administration and handling of such installation. best regards Jarek -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscrip