Thread: request wiki.postgres editor privs
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 :)
On 2018-May-29, Justin Pryzby wrote: > I'm requesting wiki editor privs for user:justinpryzby. Granted. -- Álvaro Herrera https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services