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.
