On 11 Dec 2002 at 12:52, Nicolai Tufar wrote:
> OS caching is generally considered a waste of resource in databases.
> Try to allocate as much as possible to shared buffers and set OS caching
> to minimum.
That is an exactly opposite of the truth. Leave as much for OS cache and do
minimum use of shared buffers.
Initially upping the shared buffers help but at some pointthe advantage starts
to disappear. Decide that figure with trial and error but certainly it will be
around 100-200MB for most cases..
Bye
Shridhar
--
Intuition, however illogical, is recognized as a command prerogative. -- Kirk,
"Obsession", stardate 3620.7