Re: [GENERAL] Multiple postgres.exe On Processes

On Thu, Feb 12, 2009 at 1:21 AM, Serge Fonville 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

Re: [GENERAL] Multiple postgres.exe On Processes

Dear All, Thanks John R Pierce for replying fruitful text. I wold like to add some text in your reply from PostgreSQL document for further clarification. i.e. Each connection runs one process, plus the 3 master processes for the postmaster, the writer, etc. with two logins, I'd expect to s

Re: [GENERAL] Multiple postgres.exe On Processes

Just adding: > 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 please be advised that the default-view of TaskManage

Re: [GENERAL] Multiple postgres.exe On Processes

poor windows users -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Multiple postgres.exe On Processes

> > 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. > I did some more searching and foundIs PostgreSQL multi-threaded?

Re: [GENERAL] Multiple postgres.exe On Processes

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

Re: [GENERAL] Multiple postgres.exe On Processes

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

[GENERAL] Multiple postgres.exe On Processes

Dear All, 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. Regards, Abdul Rehman.