Re: VACUUM FULL out of memory

On Tue, Jan 08, 2008 at 12:33:34PM -0500, Tom Lane wrote:
> Andrew Sullivan <ajs(at)crankycanuck(dot)ca> writes:
> > On one system I used many years ago, /bin/sh wasn't what I thought it was,
> > and so the ulimit that I got when logged in was not what the postmaster was
> > starting under. Took me many days to figure out what was up.
>
> The only thing I find convincing is to insert "ulimit -a >someplace"
> into the script that starts the postmaster, adjacent to where it does
> so, and then reboot. There are too many systems on which daemons are
> launched under settings different from what interactive shells use
> (a policy that's often a good one, too).

What about a stored procedure in a language that allows you to do
system(3) calls?

Sam