Re: VACUUM FULL out of memory

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Michael Akinde <michael(dot)akinde(at)met(dot)no>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: VACUUM FULL out of memory
Date: 2008-01-07 19:43:30
Message-ID: 24230.1199735010@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

Responses

Browse pgsql-hackers by date

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