Re: Is PostgreSQL multi-threaded?

Rich Teer wrote:
>
> On Mon, 29 May 2000, Joseph Shraibman wrote:
>
> > > Postgresql works under a multi-process model, it will take advantage
> > > of multiple processors.  However it not multi-threaded.
> > >
> > So in other words, it *is* multithreaded.  It just uses heavyweight
> > threads.
>
> Thanks - but I did mean (light weight) threads, as opposed to processes.
> I think the former can be more efficient than the latter - although perhaps
> a bit more tricky to design well!

Whenever someone talks about multithreaded, I think they are
missing something important. Namely, that the performance
difference between threads and processes is really not that
great and separate processes are far and away more robust.
It's almost impossible for one backend to accedently affect
another.
--
Martijn van Oosterhout <kleptog@cupid.suninternet.com>
http://cupid.suninternet.com/~kleptog/