Re: Many instances of postgres.exe

Поиск
Список
Период
Сортировка
От Massa, Harald Armin
Тема Re: Many instances of postgres.exe
Дата
Msg-id e3e180dc0910150908g5bdcbf17y789ee68f61be4110@mail.gmail.com
обсуждение исходный текст
Ответ на Many instances of postgres.exe  ("Bob Pawley" <rjpawley@shaw.ca>)
Список 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 по дате отправления:

Предыдущее
От: John R Pierce
Дата:
Сообщение: Re: Many instances of postgres.exe
Следующее
От: Scott Mead
Дата:
Сообщение: Re: Many instances of postgres.exe