On Sat, Aug 12, 2017 at 10:16:01PM +0200, Stefan Kaltenbrunner wrote:
> On 08/12/2017 09:05 PM, Justin Pryzby wrote:
> >https://wiki.postgresql.org/wiki/FAQ#How_does_PostgreSQL_use_CPU_resources.3F
[...]
> >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 :)
On Tue, May 29, 2018 at 08:47:13PM -0400, Alvaro Herrera wrote:
> On 2018-May-29, Justin Pryzby wrote:
> > I'm requesting wiki editor privs for user:justinpryzby.
> Granted.
Thank you :)
I finally changed:
https://wiki.postgresql.org/index.php?title=FAQ&diff=32001&oldid=30780
|How does PostgreSQL use CPU resources?
|The PostgreSQL server is process-based (not threaded). Each database session
|connects to a single PostgreSQL operating system (OS) process. Multiple
|sessions are automatically spread across all available CPUs by the OS. The OS
|also uses CPUs to handle disk I/O and run other non-database tasks. Client
|applications can use threads, each of which connects to a separate database
|process. Since version 9.6, portions of some queries can be run in parallel, in
|separate OS processes, allowing use of multiple CPU cores. Parallel queries are
|enabled by default in version 10 (max_parallel_workers_per_gather), with
|additional parallelism expected in future releases.
Justin