Re: Multiple postgres.exe On Processes

From: Serge Fonville <serge(dot)fonville(at)gmail(dot)com>
To: Abdul Rahman <abr_ora(at)yahoo(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Multiple postgres.exe On Processes
Date: 2009-02-12 08:21:50
Message-ID: 680cbe0e0902120021p2a5bf80ep32aa59e7db87243@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

> I have fear that sufficient increase in number of postgres.exe after one
> or two logins on servers may down the speed of the server or even server. Is
> there any solution or technique to overcome this overhead.
>

Did you test this?
What OS are you using?

With PostgreSQL every connection gets a process, processes can be reused, so
unless you have a very low spec system, that should not be a problem.

PostgreSQL is designed as a client/server architecture, which requires
> separate processes for each client and server, and various helper processes.
> Many embedded architectures can support such requirements. However, if your
> embedded architecture requires the database server to run inside the
> application process, you cannot use Postgres and should select a
> lighter-weight database solution.
>

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

Hope this helps

Regards,

Serge Fonville

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Serge Fonville 2009-02-12 08:28:28 Re: Multiple postgres.exe On Processes
Previous Message John R Pierce 2009-02-12 08:20:15 Re: Multiple postgres.exe On Processes