Jim, list,
from your link:
ttp://www.varlena.com/GeneralBits/Tidbits/annotated_conf_e.html
I quote:
"""As a rule of thumb, observe shared memory usage of PostgreSQL with tools like ipcs and determine the setting. Remember that this is only half the story. You also need to set effective_cache_size so that postgreSQL will use available memory optimally.
"""
and add the question (not necessarily to you):
-what is the best way to obsere shared memory usage on win32?
- which memory-size should be taken for "effective_cache_size" on windows servers with multpile purposes (i.e.: more then PostgreSQL running on them)
Available are (propable ones): physical memory, system cache, available memory (depends on system load)
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.