Re: [PERFORM] More cores or higer frequency ?
| От | Steve Crawford |
|---|---|
| Тема | Re: [PERFORM] More cores or higer frequency ? |
| Дата | |
| Msg-id | CAEfWYyw6d72mpLiaaOHbAjhNsGR+_pM3saTY8EWw5Y+3szwKWg@mail.gmail.com обсуждение исходный текст |
| Ответ на | [PERFORM] More cores or higer frequency ? (Jarek <jarek@poczta.srv.pl>) |
| Ответы |
Re: [PERFORM] More cores or higer frequency ?
|
| Список | pgsql-performance |
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@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
В списке pgsql-performance по дате отправления: