From: Harald Armin Massa <haraldarminmassa@gmail.com>
To: pgsql-performance@postgresql.org
Subject: measuring shared memory usage on Windows
Date: Mon, 16 Oct 2006 11:15:58 +0200
Message-ID: <7be3f35d0610160215v21edbe48vc144200a83f41dd0@mail.gmail.com> (raw)
Hello,
Shridhar Daithankar and Josh Berkus write on
http://www.varlena.com/varlena/GeneralBits/Tidbits/perf.html
shared_memory
"""
There is one way to decide what is best for you. Set a high value of
this parameter and run the database for typical usage. Watch usage of
shared memory using ipcs or similar tools. A recommended figure would
be between 1.2 to 2 times peak shared memory usage.
"""
I tried to find a way to do this on windows. Scanning all the lines of
perfmon memory options, I could not see anithing like "shared memory
usage".
Googling for "shared memory usage" just drove me to some ancient WRONG
information that PostgreSQL is not possible on Windows because of
lacking shared memory. (guess that was for Windows 95 or similiar)
So: has anybody a hint how I can check how much shared_memory is
really used by PostgreSQL on Windows, to fine tune this parameter?
I learned the hard way that just rising it can lead to a hard
performance loss :)
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
Subject: Re: measuring shared memory usage on Windows
In-Reply-To: <7be3f35d0610160215v21edbe48vc144200a83f41dd0@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