Skip site navigation (1) Skip section navigation (2)

Re: Using Threads?

From: The Hermit Hacker <scrappy(at)hub(dot)org>
To: Junfeng Zhang <junfengz(at)cae(dot)wisc(dot)edu>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Using Threads?
Date: 2000-12-04 12:55:53
Message-ID: Pine.BSF.4.21.0012040854240.1558-100000@thelab.hub.org (view raw or flat)
Thread:
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?

Several reasons, 'historical' probably being the strongest right now
... since PostgreSQL was never designed for threading, its about as
'un-thread-safe' as they come, and cleaning that up will/would be a
complete nightmare (should eventually be done, mind you) ...

The other is stability ... right now, if one backend drops away, for
whatever reason, it doesn't take down the whole system ... if you ran
things as one process, and that one process died, you just lost your whole
system ...



In response to

Responses

pgsql-hackers by date

Next:From: Michael ForkDate: 2000-12-04 13:25:54
Subject: Re: beta testing version
Previous:From: Jan WieckDate: 2000-12-04 12:52:50
Subject: Wrong FOR UPDATE lock type

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group