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? -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
