Re: Using Threads?
Karel Zak <zakkr@zf.jcu.cz>
From: Karel Zak <zakkr@zf.jcu.cz>
To: Junfeng Zhang <junfengz@cae.wisc.edu>
Cc: pgsql-hackers@postgresql.org
Date: 2000-12-04T11:23:34Z
Lists: pgsql-hackers
On Mon, 27 Nov 2000, Junfeng Zhang wrote: > Hello all, > > I am new to postgreSQL. When I read the documents, I find out the Postmaster > daemon actual spawns a new backend server process to serve a new client > request. Why not use threads instead? Is that just for a historical reason, > or some performance/implementation concern? It's a little a historical reason, but not only. The PostgreSQL allows to use user defined modules (functions), it means that bad module or bug in core code crash one backend only, but postmaster run still. In the thread model crash all running backend. Big differntion is in the lock method too. Karel