Re: Multiple postgres.exe On Processes

On Thu, Feb 12, 2009 at 1:21 AM, Serge Fonville
<serge(dot)fonville(at)gmail(dot)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.