Re: Using Threads?
Bruce Momjian <pgman@candle.pha.pa.us>
From: Bruce Momjian <pgman@candle.pha.pa.us>
To: Tom Samplonius <tom@sdf.com>
Cc: Junfeng Zhang <junfengz@cae.wisc.edu>, Thomas Lockhart <lockhart@alumni.caltech.edu>, pgsql-hackers@postgresql.org
Date: 2000-12-09T05:25:16Z
Lists: pgsql-hackers
> > On Mon, 4 Dec 2000, Junfeng Zhang wrote: > > > All the major operating systems should have POSIX threads implemented. > > Actually this can be configurable--multithreads or one thread. > > I don't understand this. The OS can be configured for one thread? How > would that be any of use? > > > Thread-only server is unsafe, I agree. Maybe the following model can be a > > little better. Several servers, each is multi-threaded. Every server can > > support a maximum number of requests simultaneously. If anything bad > > happends, it is limited to that server. > > There is no difference. If anything bad happens with the current > multi-process server, all the postgres backends shutdown because the > shared memory may be corrupted. Yes. Are we adding reliability with per-process backends. I think so because things are less likely to go haywire, and we are more likely to be able to clean things up in a failure. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026