Hannu Krosing wrote: > > On Thu, 2002-05-09 at 22:36, mlw wrote: > > Scott Marlowe wrote: > > > note > > > that many Unixes prefer multi-threaded models as well (Solaris comes to > > > mind) so there's the possibility that a multi-threaded postgresql could > > > enjoy better performance on more than just windows. > > > > The isolation of a process is very important to reliable operation. Going > > threaded usually means allowing a single connection to bring down the whole > > server. > > AFAIK we do that already in forked model - any time postmaster thinks > that a dying child has corrupted shared memory it kills all its > children.
I know there are cases when postmaster will kill all its children, but take the case of a faulty user function that gets a segfault. That process dies and the others continue. Without a lot of OS specific crap in postgres, that sort of behavior would be difficult to have with a threaded server. ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])