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 3FC6FD1D132 for ; Fri, 27 Feb 2004 18:27:47 +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 74352-04 for ; Fri, 27 Feb 2004 14:27:28 -0400 (AST) Received: from five.zapatec.com (66-117-150-100.web.lmi.net [66.117.150.100]) by svr1.postgresql.org (Postfix) with ESMTP id 81131D1B904 for ; Fri, 27 Feb 2004 14:27:27 -0400 (AST) Received: from rlx11.zapatec.com (rlx11.pr.zapatec.com [192.168.1.132]) by five.zapatec.com (Postfix) with ESMTP id 191DD5D23 for ; Fri, 27 Feb 2004 10:27:27 -0800 (PST) Received: (from dror@localhost) by rlx11.zapatec.com (8.12.3/8.12.3/Submit) id i1RIRQN6084500 for pgsql-performance@postgresql.org; Fri, 27 Feb 2004 10:27:26 -0800 (PST) (envelope-from dror) Date: Fri, 27 Feb 2004 10:27:26 -0800 From: Dror Matalon To: pgsql-performance@postgresql.org Subject: Re: FreeBSD config Message-ID: <20040227182726.GB82930@rlx11.zapatec.com> References: <20040226180345.GU26787@rlx11.zapatec.com> <20040226191616.GA26787@rlx11.zapatec.com> <20040226230606.GG49146@smtp.k12us.com> <20040226234246.GN26787@rlx11.zapatec.com> <403EEEB8.3080807@frodo.hserus.net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <403EEEB8.3080807@frodo.hserus.net> X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/316 X-Sequence-Number: 5840 I guess the thing to do is to move this topic over to a freebsd list where we can get more definitive answers on how disk caching is handled. I asked here since I know that FreeBsd is often recommended, http://www.varlena.com/varlena/GeneralBits/Tidbits/perf.html# as a good platform for postgres, and with Modern machines often having Gigabytes of memory the issue of, possibly, having a disk cache of 200MB would be one often asked. On Fri, Feb 27, 2004 at 12:46:08PM +0530, Shridhar Daithankar wrote: > 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 -- Dror Matalon Zapatec Inc 1700 MLK Way Berkeley, CA 94709 http://www.fastbuzz.com http://www.zapatec.com