Re: vacuumdb ERROR: out of memory

Tom Lane wrote:
> David Kerr <dmk@mr-paradox.net> writes:
>> Tom Lane wrote:
>>> David Kerr <dmk@mr-paradox.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