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

From: Hannes Erven <hannes(at)erven(dot)at>
To: pgsql-general(at)postgresql(dot)org
Cc: scottm(at)openscg(dot)com
Subject: Re: Per-session memory footprint (9.0/windows)
Date: 2011-03-02 22:24:04
Message-ID: 4D6EC384.8010401@erven.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2011-03-02 22:42:42 Re: Per-session memory footprint (9.0/windows)
Previous Message Ioana Danes 2011-03-02 21:02:39 Re: select DISTINCT not ordering the returned rows