Editing PostgreSQL (section)

=== Concurrency model ===
PostgreSQL server is [[process (computing)|process]]-based (not threaded), and uses one operating system process per database session. Multiple sessions are automatically spread across all available CPUs by the operating system. Many types of queries can also be parallelized across multiple background worker processes, taking advantage of multiple CPUs or cores.<ref>{{Cite web |url=https://lwn.net/Articles/689387/ |title=PostgreSQL 9.6 Beta and PGCon 2016 |last=Berkus |first=Josh |date=June 2, 2016 |website=LWN.net}}</ref> Client applications can use threads and create multiple database connections from each thread.<ref>{{Cite web |url=https://wiki.postgresql.org/wiki/FAQ#How_does_PostgreSQL_use_CPU_resources.3F |title=FAQ – PostgreSQL wiki |website=wiki.postgresql.org |language=en |access-date=April 13, 2017}}</ref>