Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 79D629F9B33 for ; Mon, 22 Oct 2007 14:31:36 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 45461-09 for ; Mon, 22 Oct 2007 14:31:28 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from mail01.enterprisedb.com (webmail.enterprisedb.com [63.246.7.168]) by postgresql.org (Postfix) with ESMTP id D73869F9AE4 for ; Mon, 22 Oct 2007 14:31:29 -0300 (ADT) thread-index: AcgU0WxlAznXZcsSTiac96+afVC0hA== Received: from [192.168.1.33] ([86.0.91.91]) by mail01.enterprisedb.com over TLS secured channel with Microsoft SMTPSVC(6.0.3790.3959); Mon, 22 Oct 2007 13:31:46 -0400 Message-ID: <471CDE2A.1040401@enterprisedb.com> Content-Class: urn:content-classes:message Importance: normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.4133 Date: Mon, 22 Oct 2007 18:30:18 +0100 From: "Heikki Linnakangas" User-Agent: Icedove 1.5.0.12 (X11/20070730) MIME-Version: 1.0 To: "Peter Koczan" Cc: "Lee Keel" , Subject: Re: Memory Settings.... References: <76758090F8686C47A44B6FF52514A1D30904E0B5@hermes.uai.int> <4544e0330710221015v3e723b76kd490bca99d252b9e@mail.gmail.com> In-Reply-To: <4544e0330710221015v3e723b76kd490bca99d252b9e@mail.gmail.com> Content-Type: text/plain; charset="ISO-8859-1" Content-Transfer-Encoding: 7bit X-OriginalArrivalTime: 22 Oct 2007 17:31:47.0203 (UTC) FILETIME=[6BF57D30:01C814D1] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200710/243 X-Sequence-Number: 27265 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