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 801C3D1B901 for ; Thu, 26 Feb 2004 19:16:38 +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 48528-10 for ; Thu, 26 Feb 2004 15:16:18 -0400 (AST) Received: from rlx13.zapatec.com (66-117-144-213.zapatec.lmi.net [66.117.144.213]) by svr1.postgresql.org (Postfix) with ESMTP id C1B4DD1DF4D for ; Thu, 26 Feb 2004 15:16:16 -0400 (AST) Received: from rlx11.zapatec.com (rlx11.pr.zapatec.com [192.168.1.132]) by rlx13.zapatec.com (Postfix) with ESMTP id A9DFFA941 for ; Thu, 26 Feb 2004 11:16:17 -0800 (PST) Received: (from dror@localhost) by rlx11.zapatec.com (8.12.3/8.12.3/Submit) id i1QJGGjq077511 for pgsql-performance@postgresql.org; Thu, 26 Feb 2004 11:16:16 -0800 (PST) (envelope-from dror) Date: Thu, 26 Feb 2004 11:16:16 -0800 From: Dror Matalon To: pgsql-performance@postgresql.org Subject: Re: FreeBSD config Message-ID: <20040226191616.GA26787@rlx11.zapatec.com> References: <20040226180345.GU26787@rlx11.zapatec.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/302 X-Sequence-Number: 5826 On Thu, Feb 26, 2004 at 11:55:31AM -0700, scott.marlowe wrote: > On Thu, 26 Feb 2004, Dror Matalon wrote: > > > Hi, > > > > We have postgres running on freebsd 4.9 with 2 Gigs of memory. As per > > repeated advice on the mailing lists we configured effective_cache_size > > = 25520 which you get by doing `sysctl -n vfs.hibufspace` / 8192 > > > > Which results in using 200Megs for disk caching. > > > > Is there a reason not to increase the hibufspace beyond the 200 megs and > > provide a bigger cache to postgres? I looked both on the postgres and > > freebsd mailing lists and couldn't find a good answer to this. > > Actually, I think you're confusing effective_cache_size with > shared_buffers. No, I'm not. > > 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. > > Making it bigger only tells the query planny it's more likely the data > it's looking for will be in cache. > > shared_buffers, OTOH, sets the amount of cache that postgresql uses. It's > generall considered that 256 Megs or 1/4 of memory, whichever is LESS, is > a good setting for production database servers. > Actually last I looked, I thought that the recommended max shared buffers was 10,000, 80MB, even on machines with large amounts of memory. Regards, Dror -- Dror Matalon Zapatec Inc 1700 MLK Way Berkeley, CA 94709 http://www.fastbuzz.com http://www.zapatec.com