Re: Multiple postgres.exe On Processes

From: Abdul Rahman <abr_ora(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Cc: pierce(at)hogranch(dot)com
Subject: Re: Multiple postgres.exe On Processes
Date: 2009-02-12 10:14:40
Message-ID: 331110.58196.qm@web65709.mail.ac4.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 see 5
processes. with 102 concurrent logins, 105 processes.[From Pierce]

The PostgreSQL server can handle multiple concurrent connections from clients. For that purpose it starts
(“forks”) a new process for each connection. From that point on, the client and the new server process
communicate without intervention by the original postgres process. Thus, the master server process is
always running, waiting for client connections, whereas client and associated server processes come and
go.[From PostgreSQL Document]

Thanks all.

Regards,
Abdul Rehman

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Sam Mason 2009-02-12 12:11:28 Re: Making a result of transaction visible to everyone, saving the ability for a rollback
Previous Message Sim Zacks 2009-02-12 10:03:26 Re: row constructors