Re: Per-session memory footprint (9.0/windows)

Поиск
Список
Период
Сортировка
От Hannes Erven
Тема Re: Per-session memory footprint (9.0/windows)
Дата
Msg-id 4D6EC384.8010401@erven.at
обсуждение исходный текст
Ответ на Re: Per-session memory footprint (9.0/windows)  (Scott Mead <scottm@openscg.com>)
Ответы Re: Per-session memory footprint (9.0/windows)  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Scott,


>     It seems that each of the server postmaster.exe processes takes up
>     approx. 5 MB of server memory (the "virtual memory size" column in task
>     manager), and I guess this truly is the private memory these processes
>     require. This number is roughly the same for 8.4 and 9.0 .
>
> Task manager is mis-leading as multiple processes are sharing memory.
> You need process explorer

That's exactly why I did not use the "default" columns of the Task
Manager, but "virtual memory size". I now compared the numbers to the
"private memory" column of Process Explorer, and Process Explorer shows
about 800k even more usage the the Task Manager.

It is still about 5 MB of private memory per "idle" backend process. Is
there anything I can do to optimize?


Thanks again,

    -hannes

В списке pgsql-general по дате отправления:

Предыдущее
От: Ioana Danes
Дата:
Сообщение: Re: select DISTINCT not ordering the returned rows
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Per-session memory footprint (9.0/windows)