Re: Let's make PostgreSQL multi-threaded

Andres Freund <andres@anarazel.de>

From: Andres Freund <andres@anarazel.de>
To: Jose Luis Tallon <jltallon@adv-solutions.net>
Cc: "Jonathan S. Katz" <jkatz@postgresql.org>, Heikki Linnakangas <hlinnaka@iki.fi>, Tom Lane <tgl@sss.pgh.pa.us>, pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2023-06-08T15:57:15Z
Lists: pgsql-hackers
On 2023-06-08 14:01:16 +0200, Jose Luis Tallon wrote:
> * For "heavyweight" queries, the scalability of "almost independent"
> processes w.r.t. NUMA is just _impossible to achieve_ (locality of
> reference!) with a pure threaded system. When CPU+mem-bound
> (bandwidth-wise), threads add nothing IMO.

I don't think this is true in any sort of way.