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? |