Re: Kernel cache vs shared_buffers

[Heikki Linnakangas <heikki(at)enterprisedb(dot)com>]

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