Received: from localhost (wm.hub.org [200.46.204.128])
	by postgresql.org (Postfix) with ESMTP id EAFBD9FB1B8
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Fri, 20 Oct 2006 05:01:45 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024)
	with ESMTP id 63988-01 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Fri, 20 Oct 2006 08:00:20 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-
Received: from py-out-1112.google.com (py-out-1112.google.com
 [64.233.166.178])
	by postgresql.org (Postfix) with ESMTP id A56389FB2F9
	for <pgsql-performance@postgresql.org>;
	Fri, 20 Oct 2006 05:00:19 -0300 (ADT)
Received: by py-out-1112.google.com with SMTP id d80so19462pyd
	for <pgsql-performance@postgresql.org>;
	Fri, 20 Oct 2006 01:00:18 -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:references;
	b=OZ0wugewlCP0yCaOfkw6P7B24L406vGBZJuiYkEGZtdWB58uzD3cddnO83UN7UESOcBtA+sFCR5TapO6N+AcX8cMYATnLxWxURmV+JzHh7Q2VGJb+OLuYucPQKmJbEhvRhUXY8YsmsIORFRzWuh3COb87nWwijuS6QpJCQeOLBw=
Received: by 10.35.76.9 with SMTP id d9mr106946pyl;
	Fri, 20 Oct 2006 01:00:17 -0700 (PDT)
Received: by 10.35.33.2 with HTTP; Fri, 20 Oct 2006 01:00:17 -0700 (PDT)
Message-ID: <7be3f35d0610200100u7b702a00i4c597b178c5d0fa4@mail.gmail.com>
Date: Fri, 20 Oct 2006 10:00:17 +0200
From: "Harald Armin Massa" <haraldarminmassa@gmail.com>
To: "Mark Kirkwood" <markir@paradise.net.nz>
Subject: Re: measuring shared memory usage on Windows
Cc: pgsql-performance@postgresql.org
In-Reply-To: <45370607.4080308@paradise.net.nz>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_15214_24249345.1161331217633"
References: <7be3f35d0610160215v21edbe48vc144200a83f41dd0@mail.gmail.com>
	<4533815E.3050301@boreham.org>
	<7be3f35d0610161312r3ff84fcy4dcb85e9c71fa1e2@mail.gmail.com>
	<7be3f35d0610161313y7d9b5a6ewff090db6fb25585@mail.gmail.com>
	<45370607.4080308@paradise.net.nz>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.574 tagged_above=0 required=5
	tests=DNS_FROM_RFC_ABUSE, HTML_30_40, HTML_MESSAGE, SPF_PASS
X-Spam-Level: 
X-Archive-Number: 200610/425
X-Sequence-Number: 21554

------=_Part_15214_24249345.1161331217633
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Mark,

> And THAT is exactly the challenge of this thread: I am searching for
> > tools to check shared memory usage on Windows. ipcs is not available.
> > And neither Magnus nor Dave, both main contributors of the win32 port
> > of PostgreSQL, and both way wiser concerning Windows internas then me,
> > know of some :(



Would it help to have the postmaster report what the shared memory
> allocation is when it starts up? (this won't help with the activity
> stuff, but at least you would know for sure how *much* you have to use).
>
> That would be of no use ... I am quite sure that PostgreSQL allocates the
memory as specified; that is: as much as is written in postgresql.conf.

The interesting part is usage of shared memory through the workload.

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.

------=_Part_15214_24249345.1161331217633
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Mark,<br><br><div><blockquote class=3D"gmail_quote" style=3D"border-left: 1=
px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"=
>&gt; And THAT is exactly the challenge of this thread: I am searching for<=
br>
&gt; tools to check shared memory usage on Windows. ipcs is not available.<=
br>&gt; And neither Magnus nor Dave, both main contributors of the win32 po=
rt<br>&gt; of PostgreSQL, and both way wiser concerning Windows internas th=
en me,
<br>&gt; know of some :(</blockquote><div>&nbsp;</div><br><blockquote class=
=3D"gmail_quote" style=3D"border-left: 1px solid rgb(204, 204, 204); margin=
: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Would it help to have the postmast=
er report what the shared memory
<br>allocation is when it starts up? (this won't help with the activity<br>=
stuff, but at least you would know for sure how *much* you have to use).<br=
><br></blockquote></div>That would be of no use ... I am quite sure that Po=
stgreSQL allocates the memory as specified; that is: as much as is written =
in=20
postgresql.conf. <br><br>The interesting part is usage of shared memory thr=
ough the workload. <br><br>Harald<br><br>-- <br>GHUM Harald Massa<br>persua=
dere et programmare<br>Harald Armin Massa<br>Reinsburgstra=DFe 202b<br>7019=
7 Stuttgart
<br>0173/9409607<br>-<br>Python: the only language with more web frameworks=
 than keywords.

------=_Part_15214_24249345.1161331217633--