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