Large amount of postgres processes - Mailing list pgsql-admin

From Lukasz Brodziak
Subject Large amount of postgres processes
Date
Msg-id CAGWYGjUPU1KZpRRXyir9OCBRE0Jb=wf7eXMv+mfOOGkaTTa3dg@mail.gmail.com
Whole thread Raw
List pgsql-admin
Hello,

I have a question regarding the way PG runs on Windows machines. I
have PG 9.0 installed on Windows 2008 Server Standard. When it runs
without any traffic I have 6 postgres.exe processes running. When I
run software which connects to the DB on local host I have 7 (so +1
that I can understand) but when remote hosts connect i goes up to 40
postgres.exe running on server. My question is why there are so many
postgres.exe running when nothing is connecteg to the server and each
remote connection triggers next 2 - 3 instances?


All connected hosts are working actively on the db performing sever
SELECTS as well as INSERT / UPDATE statements per transaction.
--
Łukasz Brodziak

pgsql-admin by date:

Previous
From: Matheus de Oliveira
Date:
Subject: Re: Automatic Failover Hot Standby / Streaming replication
Next
From: Lennin Caro
Date:
Subject: Re: Automatic Failover Hot Standby / Streaming replication