Re: Many instances of postgres.exe - Mailing list pgsql-general

From Massa, Harald Armin
Subject Re: Many instances of postgres.exe
Date
Msg-id e3e180dc0910150908g5bdcbf17y789ee68f61be4110@mail.gmail.com
Whole thread Raw
In response to Many instances of postgres.exe  ("Bob Pawley" <rjpawley@shaw.ca>)
List pgsql-general
Bob,
 
While looking at an error message for iexplore.exe, I noticed, on Task Manager, that there are 5 or more instances of postgres.exe running. Each instance is consuming between 7 to 10 megs of resources, for a total of almost 50 megs.
 
Is this normal behavour?

5 instances is the default when nothing has connected. 

Reason: statwriter, autovacuum, ... are all separate processes. For every additional connection there is another process, also giving a postgres.exe

What most likely is "wrong" are those "50 megs", as I guess you are looking at the default task manager.

Within those 50MB the PostgreSQL shared memory is counted (number of processes) time. That is: If there are 8MB of shared memory configured, you will see them as 40MB with 5 running processes.

Look within "View", "Select other columns" to find other memory columns.

best wishes,

Harald

 


--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Spielberger Straße 49
70435 Stuttgart
0173/9409607
no fx, no carrier pigeon
-
%s is too gigantic of an industry to bend to the whims of reality

pgsql-general by date:

Previous
From: John R Pierce
Date:
Subject: Re: Many instances of postgres.exe
Next
From: Scott Mead
Date:
Subject: Re: Many instances of postgres.exe