Re: Tuning for PostGreSQL Database

From: Jim C. Nasby (jim_at_nasby.net)
Date: 07/20/03

  • Next message: Tom Samplonius: "Re: Tuning for PostGreSQL Database" 
    Date: Sun, 20 Jul 2003 11:42:37 -0500
To: Sean Chittenden <sean@chittenden.org>

    On Sun, Jul 20, 2003 at 04:09:39AM -0700, Sean Chittenden wrote:
    > > Are there optimal parameters for sizing on the disk
    > > throughput?
    >
    > Increase your file system cache.
     
    How? I've been wondering if there's a way to do this, and all the
    settings I've played with seem to have no effect; it just sits at
    199BUF according to top. 

    -- 
Jim C. Nasby, Database Consultant                  jim@nasby.net
Member: Triangle Fraternity, Sports Car Club of America
Give your computer some brain candy! www.distributed.net Team #1828
Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"
_______________________________________________
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: Tom Samplonius: "Re: Tuning for PostGreSQL Database"

    Relevant Pages

    • Re: Tuning for PostGreSQL Database
      ... >> Increase your file system cache. ... > settings I've played with seem to have no effect; ... kind of info. `sysctl -d vfs.bufspace` ... I've attached an untested patch that lets you see what your kern.nbufs ...
      (freebsd-performance)
    • Re: FC2 + newest openoffice = slower
      ... months old (Athlon XP-M 2800+, 512meg ram, new HD). ... he manages to get 20MB/sec throughput with his changes. ... Most interestingly, despite the MUCH newer hardware I'm running, my throughput ... Even with the same settings he uses. ...
      (Fedora)
    • Re: tcp troughput weirdness
      ... Congratulations! ... But I wonder why the throughput of FreeBSD=>Linux ... If the settings above ... So, if it underestimates bandwidth-delay product, throughtput may be ...
      (freebsd-stable)
    • Re: tcp troughput weirdness
      ... Congratulations! ... But I wonder why the throughput of FreeBSD=>Linux ... If the settings above ... So, if it underestimates bandwidth-delay product, throughtput may be ...
      (freebsd-net)
    • Quantcast