Re: vacuumdb ERROR: out of memory

Tom Lane wrote:
> David Kerr <dmk(at)mr-paradox(dot)net> writes:
>> Tom Lane wrote:
>>> David Kerr <dmk(at)mr-paradox(dot)net> writes:
>>>> I get:
>>>> vacuumdb: vacuuming of database "assessment" failed: ERROR: out of memory
>>>> DETAIL: Failed on request of size 1073741820.
>>> What have you got maintenance_work_mem set to?
>
>> maintenance_work_mem = 1GB
>
> So evidently, when it tries to actually allocate 1GB, it can't do it.
> Ergo, that setting is too high for your machine.
>
> regards, tom lane
>

AHhh, ok. I was thinking that it was filling up the 1GB i allocated to it.

I just dropped the memory allocated to the instance down by about 10GB
and i'm still getting the error though.

> free
total used free shared buffers cached
Mem: 34997288 32821828 2175460 0 227420 32541844
-/+ buffers/cache: 52564 34944724
Swap: 530136 36 530100

seems like i've got 2GB free.

Food for thought..

I'll look more into it tomorrow morning though.

Thanks

Dave