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?