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

[Charles Swiger]

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