Skip site navigation (1) Skip section navigation (2)

Re: postgres.exe mem usage in task manager

From: "Magnus Hagander" <mha(at)sollentuna(dot)net>
To: "Merlin Moncure" <merlin(dot)moncure(at)rcsonline(dot)com>,<pgsql-hackers-win32(at)postgresql(dot)org>
Subject: Re: postgres.exe mem usage in task manager
Date: 2004-04-16 16:30:20
Message-ID: 6BCB9D8A16AC4241919521715F4D8BCE34B770@algol.sollentuna.se (view raw or flat)
Thread:
Lists: pgsql-hackers-win32
> I noticed a curious thing: the task manager does not seem to 
> account for shared memory (memory mapped files) in the memory 
> usage, making it appear that that the backends are allocating 
> more memory than they really are.  

Have you checked the "Virtual Memory Size" column? (Not enabled by
default)


> I confirmed that the total allocation for all the backends 
> was reasonable by checking the system commit but if you add 
> up allocations for each backend it appears much higher. 

If the above does not work, check with the performance monitor...

Microsoft has changed the way task manager reports memory usage between
pretty much every windows version (particularly the summary fields)...
Which version are you on?


> checkpointing on win32 seems to run very fast...much faster 
> than I'm used to, but this may be do to improvements in the 
> bgwriter.  It cleans the clock of the Interix port (MS's own 
> unix runtime) by at least 15% on insert heavy situations.  
> Overall, I am just blown away on how well the whole thing 
> works compared to just a few weeks ago.

Checkpointing is a no-op on win32. sync() does nothing. (OK, not quite
no-op, it writes a checkpoint record.. But without checkpointing, that
is actually incorrect).
This is the item at the very top of the TODO list on Bruces win32 status
page (http://momjian.postgresql.org/main/writings/pgsql/win32.html). Tom
has offered to change how sync() is handled in general, which is pretty
much needed before we can fix this on Win32.


//Magnus

pgsql-hackers-win32 by date

Next:From: Merlin MoncureDate: 2004-04-16 17:40:14
Subject: Re: postgres.exe mem usage in task manager
Previous:From: Tom LaneDate: 2004-04-16 16:17:15
Subject: Re: postgres.exe mem usage in task manager

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group