Re: Is PostgreSQL multi-threaded? - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: Is PostgreSQL multi-threaded?
Date
Msg-id 3933D4F1.1F0CDC50@apex.net.au
Whole thread Raw
In response to Re: Is PostgreSQL multi-threaded?  (Rich Teer <richard.teer@rite-group.com>)
List pgsql-general
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/

pgsql-general by date:

Previous
From: "carl garland"
Date:
Subject: Re: Speed of locating tables
Next
From: "Cary O'Brien"
Date:
Subject: Re: Is PostgreSQL multi-threaded?