Re: Kernel cache vs shared_buffers

Harald Armin Massa wrote:
>> A common rule of thumb people quote here is to set shared_buffers to 1/4
>> of available RAM, and leave the rest for OS cache. That's probably a
>> good configuration to start with.
>
> And just for the record: This rule of thumb does NOT apply to
> PostgreSQL on Windows. My current rule of thumb on Windows: set
> shared_buffers to minimum * 2
> Adjust effective_cache_size to the number given as "system cache"
> within the task manager.

Why?

--
   Heikki Linnakangas
   EnterpriseDB   http://www.enterprisedb.com