building a server

From: Gmail <robjsargent(at)gmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: building a server
Date: 2017-12-03 20:47:27
Message-ID: 8CFC3898-F163-4C1D-9511-5AAC53EAACE2@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Thanks

PS The wiki page at https://wiki.postgresql.org/wiki/Database_Hardware lists a reference to a PDF by Greg Smith. The url vectors off into some proprietary e-book enticement. Is that intentional?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John R Pierce 2017-12-03 21:15:23 Re: building a server
Previous Message legrand legrand 2017-12-03 17:39:51 Re: Partition pruning / agg push down for star schema in pg v11