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 8E4D1D1B9BE for ; Fri, 27 Feb 2004 07:16:19 +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 56404-06 for ; Fri, 27 Feb 2004 03:16:18 -0400 (AST) Received: from frodo.hserus.net (frodo.hserus.net [204.74.68.40]) by svr1.postgresql.org (Postfix) with ESMTP id 45026D1B9C0 for ; Fri, 27 Feb 2004 03:16:17 -0400 (AST) Received: from concord.pspl.co.in ([202.54.11.72]:61910 helo=frodo.hserus.net) by frodo.hserus.net with asmtp (Cipher TLSv1:DHE-RSA-AES256-SHA:256) (Exim 4.30 #1) id 1AwcEL-0006UZ-3E by authid with plain; Fri, 27 Feb 2004 12:46:17 +0530 Message-ID: <403EEEB8.3080807@frodo.hserus.net> Date: Fri, 27 Feb 2004 12:46:08 +0530 From: Shridhar Daithankar User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.6b) Gecko/20031205 Thunderbird/0.4 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Dror Matalon Cc: pgsql-performance@postgresql.org Subject: Re: FreeBSD config References: <20040226180345.GU26787@rlx11.zapatec.com> <20040226191616.GA26787@rlx11.zapatec.com> <20040226230606.GG49146@smtp.k12us.com> <20040226234246.GN26787@rlx11.zapatec.com> In-Reply-To: <20040226234246.GN26787@rlx11.zapatec.com> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/313 X-Sequence-Number: 5837 Dror Matalon wrote: > Let me try and say it again. I know that setting effective_cache_size > doesn't affect the OS' cache. I know it just gives Postgres the *idea* > of how much cache the OS is using. I know that. I also know that a > correct hint helps performance. > > I've read Matt Dillon's discussion about the freebsd VM at > http://www.daemonnews.org/200001/freebsd_vm.html and I didn't see him > saying that Freebsd uses all the free RAM for disk cache. Would you care > to provide a URL pointing to that? I don't believe freeBSD yses everything available unlike linux. It is actually a good thing. If you have 1GB RAM and kernel buffers set at 600MB, you are guaranteed to have some mmory in crunch situations. As far you original questions, I think you can increase the kernel buffer sizes for VFS safely. However remembet that more to dedicate to kernel buffers, less space you have in case of crunch for whatever reasons. FreeBSD gives you a control which linux does not. Use it to best of your advantage.. Shridhar