Date: Wed, 29 Jun 2005 16:40:52 -0400 From: Charles Swiger <cswiger@mac.com> To: Sven Willenberger <sven@dmv.com> Cc: Vivek Khera <vivek@khera.org>, stable@freebsd.org, postgres general <pgsql-general@postgresql.org> Subject: Re: [GENERAL] PostgreSQL's vacuumdb fails to allocate memory for non-root users Message-ID: <51C9ABA2-20B8-4DE8-B647-A26A168A78FC@mac.com> In-Reply-To: <1120075946.19603.68.camel@lanshark.dmv.com> References: <1120050088.19603.7.camel@lanshark.dmv.com> <58067976-00C6-4380-90DF-F448D9008C81@khera.org> <1120075946.19603.68.camel@lanshark.dmv.com>
next in thread | previous in thread | raw e-mail | index | archive | help
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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?51C9ABA2-20B8-4DE8-B647-A26A168A78FC>