On 12/03/2017 02:15 PM, John R Pierce wrote:
> On 12/3/2017 12:47 PM, Gmail wrote:
>> So I revisited https://momjian.us/main/writings/pgsql/hw_selection.pdf
>> Near the end (page 24) I spotted:
>> Heavy use of server-side functions might generate significant CPU load
>>
>> Just want to confirm that this referring to workload on the
>> mainly-single-threaded server not an advocacy for more cores.
>>
> well, if you have significant concurrency with high CPU usage, you
> want both more AND faster cores
>
>
> --
> john r pierce, recycling bits in santa cruz
Granted! I suppose I'm looking for confirmation/correction on believing
that for the server to make use of multiple cores is more dependent on
the nature of the queries handled. Concurrency should not be a huge
problem for this project, though I've put pieces in place to mitigate
that issue.