Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id BD0BC9FB7D2 for ; Sun, 13 May 2007 05:39:40 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 77437-10 for ; Sun, 13 May 2007 05:39:23 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from nz-out-0506.google.com (nz-out-0506.google.com [64.233.162.224]) by postgresql.org (Postfix) with ESMTP id B68DA9FB7D0 for ; Sun, 13 May 2007 05:39:37 -0300 (ADT) Received: by nz-out-0506.google.com with SMTP id s1so1531535nze for ; Sun, 13 May 2007 01:39:36 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=P7On8wK07NUb6ZBLhgKIAnKjjlcZc1H58VHga2Qu0IgwXVhX4cHaBx/TCf4WMoTNt8ZpJNGaAXxs7N1F/6AjmsoDfZCV2NvjnN4Gk9VMP3+GUcXWdF++95X0BEo1YL6B5aG5Vy2z84WIkLz+TuyADqJQiubcIkAxBM1WEZUebW8= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=fXMKc153ssKcLc2j8pHy5Igh0+KixmkE8EOKM0mjtxyFB3nzFCBC/dKnqoO6z8Oazhdx+ZziO6YnRh2u7oyr/nFl5tBIFr7DrQ3UzuVo9nEglrWmlck4qXKuyvywwFUGuw3Z3Ia+ZN6SI+OEZH2TgVsw15S5fztDGL3T5lpDfLU= Received: by 10.115.95.1 with SMTP id x1mr537143wal.1179045576094; Sun, 13 May 2007 01:39:36 -0700 (PDT) Received: by 10.114.12.15 with HTTP; Sun, 13 May 2007 01:39:36 -0700 (PDT) Message-ID: <7be3f35d0705130139o218a2a38l6471d6c8aeb1c71f@mail.gmail.com> Date: Sun, 13 May 2007 10:39:36 +0200 From: "Harald Armin Massa" To: pgsql-performance@postgresql.org Subject: Re: Kernel cache vs shared_buffers In-Reply-To: <4645CF1D.1030309@enterprisedb.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <00b301c79486$1c54da80$0200a8c0@saturn> <4645CF1D.1030309@enterprisedb.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/243 X-Sequence-Number: 24633 > 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. Harald --=20 GHUM Harald Massa persuadere et programmare Harald Armin Massa Reinsburgstra=DFe 202b 70197 Stuttgart 0173/9409607 fx 01212-5-13695179 - Python: the only language with more web frameworks than keywords.