From: Harald Armin Massa <haraldarminmassa@gmail.com>
To: Magnus Hagander <mha@sollentuna.net>
Cc: pgsql-performance@postgresql.org
Subject: Re: measuring shared memory usage on Windows
Date: Mon, 16 Oct 2006 14:18:30 +0200
Message-ID: <7be3f35d0610160518h649c8f20pee9949a90796c346@mail.gmail.com> (raw)
In-Reply-To: <6BCB9D8A16AC4241919521715F4D8BCEA357F4@algol.sollentuna.se>
References: <7be3f35d0610160418u51e4d256k15ee2a5e4ba9433@mail.gmail.com>
<6BCB9D8A16AC4241919521715F4D8BCEA357F4@algol.sollentuna.se>
Magnus,
> > "anonymous mapped memory" site:microsoft.com
> > turns out 0 (zero) results. And even splitting it up there
> > seems to be nearly no information ... is the same thing by
> > any chance also known by different names?
>
> Hmm. Yeah, most likely :) I may have grabbed that name from something
> else. THe documentation for the call is on
> http://windowssdk.msdn.microsoft.com/en-us/library/ms685007(VS.80).aspx,
> we specify INVALID_HANDLE_VALUE for hFile, which means:
[...]
CreateFileMapping creates a file mapping object of a specified size
that _the operating system paging file backs_
[...]
I assume that DWORD dwMaximumSizeHigh and DWORD dwMaximumSizeLow
get filled with whatever I configure in shared_memory?
My reading of that function gives me the impression, that this kind of
shared *memory* is essentially a shared disk file - "_the operating
system paging file backs_"
Especially documentation lines like "If an application specifies a
size for the file mapping object that is larger than the size of the
actual named file on disk, the file on disk is increased to match the
specified size of the file mapping object."
really makes me think that that area is just a comfortable way to
access files on disk as memory areas; with the hope of propably better
caching then not-memory-mapped files.
That would explain my disturbing impressions of performance of
PostgreSQL on win32 rising when lowering shared_memory...
Harald
--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Reinsburgstraße 202b
70197 Stuttgart
0173/9409607
-
Python: the only language with more web frameworks than keywords.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: haraldarminmassa@gmail.com, mha@sollentuna.net
Subject: Re: measuring shared memory usage on Windows
In-Reply-To: <7be3f35d0610160518h649c8f20pee9949a90796c346@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox