Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id D8EA09FB7EA for ; Sun, 13 May 2007 06:57:21 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 07749-02 for ; Sun, 13 May 2007 06:57:18 -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.235]) by postgresql.org (Postfix) with ESMTP id 9FDDD9FB6EA for ; Sun, 13 May 2007 06:57:18 -0300 (ADT) Received: by nz-out-0506.google.com with SMTP id s1so1544688nze for ; Sun, 13 May 2007 02:57:17 -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:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=g4jXnrj9aif+4qmloBsnuONf2pMPFykzVfJ1JnJaeDZf/NTcuXdIBdIjU+vOG+T7+ojh48m+UkoY5OvxGDcC0k1DFf640L+RlEBaMYS0Z2Ljf9vGnxVu4+8OFsjS6/YsroDKM2b6I0GhyJlvPEVNrxgLsAHVU3ehd0xkOwqENxE= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=cS1Cm3itOrj/U9hvczgPcdn64SiYB1FZgFbaLQa1lhBsJBYYlXRSvwP9KVZ6Ywic99JR9rkhIzRnulxgDugsTkAX3NlMBwnCduMjD+JSM35ayvkrBgneAlrXz4sGkJfdtPqet2nW2XxqZupXhLEYpaf6yLkmaSVokxOrF1mlO5U= Received: by 10.114.66.2 with SMTP id o2mr569921waa.1179050236503; Sun, 13 May 2007 02:57:16 -0700 (PDT) Received: by 10.114.12.15 with HTTP; Sun, 13 May 2007 02:57:16 -0700 (PDT) Message-ID: <7be3f35d0705130257o1ce62db6t7512e964a99c23f2@mail.gmail.com> Date: Sun, 13 May 2007 11:57:16 +0200 From: "Harald Armin Massa" To: "Heikki Linnakangas" Subject: Re: Kernel cache vs shared_buffers Cc: pgsql-performance@postgresql.org In-Reply-To: <4646DD4E.4000301@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> <7be3f35d0705130139o218a2a38l6471d6c8aeb1c71f@mail.gmail.com> <4646DD4E.4000301@enterprisedb.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/245 X-Sequence-Number: 24635 Heikki, > > 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? I tried with shared_buffers =3D 50% of available memory, and with 30% of available memory, and the thoughput on complex queries stalled or got worse. I lowered shared_buffers to minimum, and started raising effective_cache_size, and performance on real world queries improved. pg_bench did not fully agree when simulating large numbers concurrent queries. So I tried setting shared_buffers between minimum and 2.5*minimum, and pg_bench speeds recovered and real world queries did similiar. My understanding is that shared_buffers are realised as memory mapped file in win32; and that they are only usually kept in memory. Maybe I understood that wrong. 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.