Re: [GENERAL] PostgreSQL's vacuumdb fails to allocate memory for non-root users

From: Sven Willenberger (sven_at_dmv.com)
Date: 06/29/05

  • Next message: John-Mark Gurney: "Re: What is considered "the best supported" RAID controller for 5.x?" 
    To: Charles Swiger <cswiger@mac.com>
Date: Wed, 29 Jun 2005 16:58:35 -0400

    On Wed, 2005-06-29 at 16:40 -0400, Charles Swiger wrote:
    > On Jun 29, 2005, at 4:12 PM, Sven Willenberger wrote:
    > [ ... ]
    > > Something I have noticed,
    > > when the memory error occurs during the psql session (after a failed
    > > vacuumdb attempt) the memory stays at 600+MB in top (under size) until
    > > the psql session is closed -- that may just be the way top reports it
    > > though.
    >
    > Double-check your system limits via "ulimit -a" or "ulimit -aH". By
    > default, FreeBSD will probably restrict the maximum data size of the
    > process to 512MB, which may be what you are running into. You can
    > rebuild the kernel to permit a larger data size, or else tweak /boot/
    > loader.conf:
    >
    > echo 'kern.maxdsiz="1024M"' >> /boot/loader.conf
    >

    :>ulimit -a
    cpu time (seconds, -t) unlimited
    file size (512-blocks, -f) unlimited
    data seg size (kbytes, -d) 1048576
    stack size (kbytes, -s) 65536
    core file size (512-blocks, -c) unlimited
    max memory size (kbytes, -m) unlimited
    locked memory (kbytes, -l) unlimited
    max user processes (-u) 5547
    open files (-n) 11095
    virtual mem size (kbytes, -v) unlimited
    sbsize (bytes, -b) unlimited
    :> cat /boot/loader.conf
    kern.maxdsiz="1073741824"
    kern.dfldsiz="891289600"

    and if I don't run vacuumdb at all, but rather connect to the backend
    via psql and run vacuum, it works ok with full memory allocation. Still
    testing RAM to see if the issue is physical.

    Sven

    _______________________________________________
    freebsd-stable@freebsd.org mailing list
    http://lists.freebsd.org/mailman/listinfo/freebsd-stable
    To unsubscribe, send any mail to "freebsd-stable-unsubscribe@freebsd.org"

  • Next message: John-Mark Gurney: "Re: What is considered "the best supported" RAID controller for 5.x?"