Re: Tuning for PostGreSQL Database

From: Sean Chittenden (sean_at_chittenden.org)
Date: 07/22/03

  • Next message: Michael Conlen: "Re: Tuning for PostGreSQL Database" 
    Date: Tue, 22 Jul 2003 11:55:27 -0700
To: Christopher Weimann <cweimann@k12hq.com>

    > > You might want to get in the habit of using sysctl for getting
    > > that kind of info. `sysctl -d vfs.bufspace`
    >
    > I'm confused. Everything I have ever read about FreeBSD indicates
    > that it uses all free ram for the disk cache.

    >From loader(8):

         kern.maxbcache
                       Limits the amount of KVM reserved for use by the buffer
                       cache, specified in bytes. The default maximum is 200MB.
                       This parameter is used to prevent the buffer cache from
                       eating too much KVM in large-memory machine configurations.
                       Only mess around with this parameter if you need to greatly
                       extend the KVM reservation for other resources such as the
                       swap zone or NMBCLUSTERS. Note that the NBUF parameter
                       will override this limit. Modifies VM_BCACHE_SIZE_MAX.

    -sc 

    -- 
Sean Chittenden
_______________________________________________
freebsd-performance@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-performance
To unsubscribe, send any mail to "freebsd-performance-unsubscribe@freebsd.org"
  • Next message: Michael Conlen: "Re: Tuning for PostGreSQL Database"

    Relevant Pages

    • RAM in a Compaq 2500.
      ... removed the Win2K server installed and replaced it with FreeBSD ... According to sysctl I seem to only have 12MB of RAM ... To unsubscribe, ...
      (freebsd-questions)
    • Re: RFC: 5.3 Migration Guide
      ... "M. Warner Losh" wrote: ... Unregistered;) FreeBSD 5.3-BETA3 "user" ... Try sysctl debug.witness_watch=0 ... To unsubscribe, ...
      (freebsd-current)
    • Re: I messed up my system, please help. library missing
      ... Sigh. ... I'm still new to FreeBSD. ... I *really* need to get in the habit of ... To unsubscribe, ...
      (freebsd-questions)
    • Re: Tuning for PostGreSQL Database
      ... > You might want to get in the habit of using sysctl for getting that ... Everything I have ever read about FreeBSD indicates ... To unsubscribe, ...
      (freebsd-performance)
    • Re: Clock running fast
      ... > sysctl kern.timecounter.hardware and sysctl kern.timecounter do ... True, this interface has changed slightly, since 4.x as 5.x has better ... useful starting point for any recent version of FreeBSD. ... To unsubscribe, ...
      (freebsd-questions)