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 ...
- [HACKERS] Using Threads? Junfeng Zhang
- Re: [HACKERS] Using Threads? Karel Zak
- Re: [HACKERS] Using Threads? Myron Scott
- Re: [HACKERS] Using Threads? Ross J. Reedstrom
- Re: [HACKERS] Using Threads? The Hermit Hacker
- Re: [HACKERS] Using Threads? Myron Scott
- Re: [HACKERS] Using Threads? Myron Scott
- Re: [HACKERS] Using Threads? Karel Zak
- Re: [HACKERS] Using Threads? Myron Scott
- [HACKERS] Re: Using Threads? mlw
- Re: [HACKERS] Using Threads? The Hermit Hacker
- Re: [HACKERS] Using Threads? Tom Lane
- Re: [HACKERS] Using Threads? Bruce Guenter
- Re: [HACKERS] Using Threads? Adam Haberlach
- Re: [HACKERS] Using Threads? Dan Lyke
- Re: [HACKERS] Using Threads? Bruce Guenter
- Re: [HACKERS] Using Threads? Tom Lane
- Re: [HACKERS] Using Threads? Bruce Momjian
- Re: [HACKERS] Using Threads? Bruce Momjian
- Re: [HACKERS] Using Threads? Bruce Guenter
- Re: [HACKERS] Using Threads? Bruce Momjian