X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 1954DD1B994 for ; Thu, 26 Feb 2004 23:06:27 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 42472-02 for ; Thu, 26 Feb 2004 19:06:11 -0400 (AST) Received: from smtp.k12us.com (smtp.k12us.com [65.112.222.15]) by svr1.postgresql.org (Postfix) with SMTP id 05F11D1D52E for ; Thu, 26 Feb 2004 19:06:08 -0400 (AST) Received: (qmail 58379 invoked by uid 1001); 26 Feb 2004 23:06:06 -0000 Date: Thu, 26 Feb 2004 18:06:06 -0500 From: Christopher Weimann To: Dror Matalon Cc: pgsql-performance@postgresql.org Subject: Re: FreeBSD config Message-ID: <20040226230606.GG49146@smtp.k12us.com> References: <20040226180345.GU26787@rlx11.zapatec.com> <20040226191616.GA26787@rlx11.zapatec.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20040226191616.GA26787@rlx11.zapatec.com> User-Agent: Mutt/1.5.4i X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/328 X-Sequence-Number: 5852 On 02/26/2004-11:16AM, Dror Matalon wrote: > > > > effective_cache_size changes no cache settings for postgresql, it simply > > acts as a hint to the planner on about how much of the dataset your OS / > > Kernel / Disk cache can hold. > > I understand that. The question is why have the OS, in this case FreeBsd > use only 200 Megs for disk cache and not more. Why not double the > vfs.hibufspace to 418119680 and double the effective_cache_size to 51040. > FreeBSD uses ALL ram that isn't being used for something else as its disk cache. The "effective_cache_size" in the PostGreSQL config has no effect on how the OS chooses to use memory, it is just hint to the PostGreSQL planner so it can guess the the likelyhood of what it is looking for being in the cache.