Michael Akinde <michael(dot)akinde(at)met(dot)no> writes:
> As suggested, I tested a VACUUM FULL ANALYZE with 128MB shared_buffers 
> and 512 MB reserved for maintenance_work_mem (on a 32 bit machine with 4 
> GB RAM). That ought to leave more than enough space for other processes 
> in the system. Again, the system fails on the VACUUM with the following 
> error (identical to the error we had when maintenance_work_mem was very 
> low.

> INFO:  vacuuming "pg_catalog.pg_largeobject"
> ERROR:  out of memory
> DETAIL:  Failed on request of size 536870912

Are you sure this is a VACUUM FULL, and not a plain VACUUM?  I suspect
that it's the latter, and the reason it's failing is that you are
running the postmaster under a ulimit that is less than 512MB (or at
least not enough more to allow an allocation of that size).

			regards, tom lane

In response to

• Re: VACUUM FULL out of memory at 2008-01-07 09:40:23 from Michael Akinde

Responses

• Re: VACUUM FULL out of memory at 2008-01-08 08:50:07 from Michael Akinde

pgsql-hackers by date

Next:	From: Hannes Dorbath	Date: 2008-01-07 19:46:01
	Subject: Re: Index trouble with 8.3b4
Previous:	From: ilanco	Date: 2008-01-07 19:16:29
	Subject: ERROR: translation failed from server encoding to wchar_t