From: | "Harald Armin Massa" <haraldarminmassa(at)gmail(dot)com> |
---|---|
To: | "Jim C(dot) Nasby" <jim(at)nasby(dot)net> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: postgresql.conf shared buffers |
Date: | 2006-10-13 08:29:57 |
Message-ID: | 7be3f35d0610130129p6189080eqaae8241929c19b29@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Rafal Pietrak | 2006-10-13 08:44:18 | Re: looping through query to update column |
Previous Message | Martijn van Oosterhout | 2006-10-13 08:22:10 | Re: Performance Problem |