Re: Multiple postgres.exe On Processes - Mailing list pgsql-general

From Scott Marlowe
Subject Re: Multiple postgres.exe On Processes
Date
Msg-id dcc563d10902121119q460f5748q94c04920b4a0ac73@mail.gmail.com
Whole thread Raw
In response to Re: Multiple postgres.exe On Processes  (Serge Fonville <serge.fonville@gmail.com>)
List pgsql-general
On Thu, Feb 12, 2009 at 1:21 AM, Serge Fonville
<serge.fonville@gmail.com> wrote:

> I could not find the reason as to why this way has been chosen by the
> developers

Because separate processes are much more robust than multiple threads.
 And on Linux, the difference in performance is minimal.  Note some
OSes like Windows, and to a lesser extent, Solaris, have significant
overhead for forking processes, and run multi-threaded apps much
faster.

Since any real db in a heavy lifting situation is probably using a
connection pooler, then the cost of startup of a new process isn't a
big deal, because they're not getting started all the time anymore.

pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Killing OIDs
Next
From: SHARMILA JOTHIRAJAH
Date:
Subject: Re: COPy command question