On 14 November 2012 06:47, Craig Ringer wrote:
> Yes, it's absurd that it's so hard to work out how much memory Pg uses. It'd
> be nice if Pg provided better tools for this by allowing the postmaster to
> interrogate backends' memory contexts, though that'd only report how much
> memory Pg thought
On 11/14/2012 01:56 PM, Wu Ming wrote:
> This is interesting. About the "virtual size of one of the process",
> which process I should look up? Is the one who has the biggest virtual
> size?
Thinking about this some more, I haven't checked to see if Windows adds
dirtied shared_buffers to the proc
Hi,
> As I said, it just isn't that simple when shared memory is involved. A
> rough measure for PostgreSQL is the "virtual size" of one of the
> processes, plus the working sets of all the others. Alternately, you can
> reasonably estimate the memory consumption by adding all the working
> sets a
Please reply to the list, not directly to me. Comments follow in-line.
On 11/13/2012 11:37 PM, Wu Ming wrote:
> Hi,
>
> What column in Process Explorer to determine memory usage? Currently I
> thought "Working Set" is the correct one.
As I said, it just isn't that simple when shared memory is invo
On 11/12/2012 10:17 PM, Wu Ming wrote:
> See this screenshot link from the Process Explorer:
>
> http://i45.tinypic.com/vr4t3b.png
That looks pretty reasonable to me.
The "virtual size" includes the shared memory segment, so the
per-process use is actually much lower than it looks. The real use wi
On Mon, Nov 12, 2012 at 8:17 AM, Wu Ming wrote:
> Hi,
>
> I had installed postgreSQL v9.2 in Windows XP SP3.
>
> My PC specs:
> Processor: Pentium Dual Core 2.09 GHz
> RAM: 2GB
>
> The postgreSQL is run as windows service (manual).
>
> The problem is the postgreSQL service uses a lot of memory and
Wu Ming wrote:
> I had installed postgreSQL v9.2 in Windows XP SP3.
>
> My PC specs:
> Processor: Pentium Dual Core 2.09 GHz
> RAM: 2GB
>
> The postgreSQL is run as windows service (manual).
>
> The problem is the postgreSQL service uses a lot of memory and lags
> the OS if running in long time
