I'm requesting wiki editor privs for user:justinpryzby.
For the change I suggested last year (copied below).
..and for a first order / mock up of this idea:
https://www.postgresql.org/message-id/20180524235713.GA32049%40telsasoft.com
On Sat, Aug 12, 2017 at 10:16:01PM +0200, Stefan Kaltenbrunner wrote:
> >https://wiki.postgresql.org/wiki/FAQ#How_does_PostgreSQL_use_CPU_resources.3F
> >|The PostgreSQL server is process-based (not threaded), and uses one operating
> >|system process per database session. A single database session (connection)
> >|cannot utilize more than one CPU. Of course, multiple sessions are
> >|automatically spread across all available CPUs by your operating system. Client
> >|applications can easily use threads and create multiple database connections
> >|from each thread.
> >|
> >|A single complex and CPU-intensive query is unable to use more than one CPU to
> >|do the processing for the query. The OS may still be able to use others for
> >|disk I/O etc, but you won't see much benefit from more than one spare core.
> >
> >I think should mention that PG96 introduces parallel query.
> >https://www.postgresql.org/docs/9.6/static/parallel-query.html
>
> thats however a wiki - please get an account and assciated editor
> permissions and hack away :)