Re: PostgreSQL's vacuumdb fails to allocate memory for

Sven Willenberger <sven(at)dmv(dot)com> writes:
> ERROR: out of memory
> DETAIL: Failed on request of size 536870910.

That's a server-side failure ...

> Again, if I log in as myself and try to run
> the command vaccumdb -a -z it fails; if I su to root and repeat it works
> fine. I am trying to narrow this down to a PostgreSQL issue vs FreeBSD
> issue.

That's fairly hard to believe, assuming that you are talking to the same
server in both cases (I have seen trouble reports that turned out to be
because the complainant was accidentally using two different servers...)
The ulimit the backend is running under couldn't change depending on
where the client is su'd to.

Is it possible that you've got per-user configuration settings that
affect this, like a different maintenance_mem value for the root user?

regards, tom lane