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

From: Charles Swiger (cswiger_at_mac.com)
Date: 06/29/05

  • Next message: Sven Willenberger: "Re: [GENERAL] PostgreSQL's vacuumdb fails to allocate memory for non-root users" 
    Date: Wed, 29 Jun 2005 16:40:52 -0400
To: Sven Willenberger <sven@dmv.com>

    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 

    -- 
-Chuck
_______________________________________________
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: Sven Willenberger: "Re: [GENERAL] PostgreSQL's vacuumdb fails to allocate memory for non-root users"