Re: Many instances of postgres.exe

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