Re: Tuning for PostGreSQL Database

From: Terry Lambert (tlambert2_at_mindspring.com)
Date: 07/26/03

  • Next message: Tom Samplonius: "Re: Tuning for PostGreSQL Database" 
    Date: Fri, 25 Jul 2003 23:33:43 -0700
To: Christopher Weimann <cweimann@k12hq.com>

    Christopher Weimann wrote:
    > So I have conflicting documentation.
    >
    > I have machine with 4Gig of ram. What is the maximum
    > value of SHMMAX on FreeBSD?

    Ideally, you would use memory mapped files for this, and not System V
    shared memory, so that the OS could implement swapping policies as it
    saw fit, and could actually swap the data, if nevcessary, instead of
    it sucking up huge amounts of wired memory.

    In any case, POSIX deprecated SysV shared memory years ago, and
    recommends that all code utilize shm_open instead, these days, if
    you insist on using an interface that sucks up huge amounts of
    wired pages and KVA space.

    -- Terry
    _______________________________________________
    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