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
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
