Re: Multiple postgres.exe On Processes

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Multiple postgres.exe On Processes
Date: 2009-02-12 08:20:15
Message-ID: 4993DBBF.8060007@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Abdul Rahman wrote:
> 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.

each connection runs one process, plus the 3 master processes for the
postmaster, the writer, etc. with two logins, I'd expect to see 5
processes. with 102 concurrent logins, 105 processes. the bulk of the
memory and code is shared by these processes, with the exception of
things like per client work_mem buffers which by definition can't be
shared as they are used to service that connections requests.

what overhead are you talking about?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Serge Fonville 2009-02-12 08:21:50 Re: Multiple postgres.exe On Processes
Previous Message Paolo Saudin 2009-02-12 08:06:41 How to check if 2 series of data are equal