Tom Lane wrote:
David Kerr <dmk@xxxxxxxxxxxxxx> writes:
Tom Lane wrote:
David Kerr <dmk@xxxxxxxxxxxxxx> 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
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
