Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 7DFFD9FB270 for ; Mon, 16 Oct 2006 09:18:44 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 84476-02 for ; Mon, 16 Oct 2006 09:18:35 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from py-out-1112.google.com (py-out-1112.google.com [64.233.166.179]) by postgresql.org (Postfix) with ESMTP id 4D51C9FB32A for ; Mon, 16 Oct 2006 09:18:34 -0300 (ADT) Received: by py-out-1112.google.com with SMTP id d80so2395438pyd for ; Mon, 16 Oct 2006 05:18:31 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=sHsrVgvfPc1JvjJoyXy2ZPVxF5cEHdFecUdNS4eSWFF2KsSyw/+AF1UOMSPtNnOYiQoPO/KD/ayQYOf4KEBE4eIn2Rdfc8QPjhlscy29P1mr7ka/VLFQ+oLtGRkNvJ0TeyJSehozrKY3T5D2UlxuqKAi9pLdvRNw4DPoGfY9Hzc= Received: by 10.35.66.13 with SMTP id t13mr12737969pyk; Mon, 16 Oct 2006 05:18:30 -0700 (PDT) Received: by 10.35.33.6 with HTTP; Mon, 16 Oct 2006 05:18:30 -0700 (PDT) Message-ID: <7be3f35d0610160518h649c8f20pee9949a90796c346@mail.gmail.com> Date: Mon, 16 Oct 2006 14:18:30 +0200 From: "Harald Armin Massa" To: "Magnus Hagander" Subject: Re: measuring shared memory usage on Windows Cc: pgsql-performance@postgresql.org In-Reply-To: <6BCB9D8A16AC4241919521715F4D8BCEA357F4@algol.sollentuna.se> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <7be3f35d0610160418u51e4d256k15ee2a5e4ba9433@mail.gmail.com> <6BCB9D8A16AC4241919521715F4D8BCEA357F4@algol.sollentuna.se> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.474 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, SPF_PASS X-Spam-Level: X-Archive-Number: 200610/291 X-Sequence-Number: 21420 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 --=20 GHUM Harald Massa persuadere et programmare Harald Armin Massa Reinsburgstra=DFe 202b 70197 Stuttgart 0173/9409607 - Python: the only language with more web frameworks than keywords.