From: | David Kerr <dmk(at)mr-paradox(dot)net> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: vacuumdb ERROR: out of memory |
Date: | 2010-02-09 04:25:50 |
Message-ID: | 4B70E3CE.8060401@mr-paradox.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | John R Pierce | 2010-02-09 04:49:30 | Re: vacuumdb ERROR: out of memory |
Previous Message | Tom Lane | 2010-02-09 04:10:03 | Re: vacuumdb ERROR: out of memory |