pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Dror Matalon <dror@zapatec.com>
To: pgsql-performance@postgresql.org
Subject: Re: FreeBSD config
Date: Fri, 27 Feb 2004 10:27:26 -0800
Message-ID: <20040227182726.GB82930@rlx11.zapatec.com> (raw)
In-Reply-To: <403EEEB8.3080807@frodo.hserus.net>
References: <20040226180345.GU26787@rlx11.zapatec.com>
	<Pine.LNX.4.33.0402261153490.10449-100000@css120.ihs.com>
	<20040226191616.GA26787@rlx11.zapatec.com>
	<20040226230606.GG49146@smtp.k12us.com>
	<20040226234246.GN26787@rlx11.zapatec.com>
	<403EEEB8.3080807@frodo.hserus.net>

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



view thread (20+ messages)  latest in thread

Message-ID: <20040227182726.GB82930@rlx11.zapatec.com>
Permalink:  ../20040227182726.GB82930@rlx11.zapatec.com/
Also on:    postgresql.org/message-id/20040227182726.GB82930@rlx11.zapatec.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: dror@zapatec.com
  Subject: Re: FreeBSD config
  In-Reply-To: <20040227182726.GB82930@rlx11.zapatec.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox