From: Heikki Linnakangas <heikki@enterprisedb.com>
To: Peter Koczan <pjkoczan@gmail.com>
Cc: Lee Keel <lee.keel@uai.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Memory Settings....
Date: Mon, 22 Oct 2007 18:30:18 +0100
Message-ID: <471CDE2A.1040401@enterprisedb.com> (raw)
In-Reply-To: <4544e0330710221015v3e723b76kd490bca99d252b9e@mail.gmail.com>
References: <76758090F8686C47A44B6FF52514A1D30904E0B5@hermes.uai.int>
<4544e0330710221015v3e723b76kd490bca99d252b9e@mail.gmail.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: heikki@enterprisedb.com, pjkoczan@gmail.com, lee.keel@uai.com
Subject: Re: Memory Settings....
In-Reply-To: <471CDE2A.1040401@enterprisedb.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox