Re: Memory Settings.... - Mailing list pgsql-performance

From Heikki Linnakangas
Subject Re: Memory Settings....
Date
Msg-id 471CDE2A.1040401@enterprisedb.com
Whole thread Raw
In response to Re: Memory Settings....  ("Peter Koczan" <pjkoczan@gmail.com>)
List pgsql-performance
Peter Koczan wrote:
> The
> basic rule of thumb for shared_buffers is 25%-50% of main memory,
> enough to use main memory but leaving some to allow work_mem to do its
> thing and allow any other programs to run smoothly. Tweak this as
> necessary.

Another rule of thumb is that on Windows you want only very little
shared_buffers, because of some performance issues with shared memory on
Windows.

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

pgsql-performance by date:

Previous
From: Ben
Date:
Subject: Re: Memory Settings....
Next
From: "Kevin Grittner"
Date:
Subject: Re: Memory Settings....