Postgres Pro
Downloads
Home   >   mailing lists

Re: vacuumdb ERROR: out of memory - Mailing list pgsql-general

From Tom Lane
Subject Re: vacuumdb ERROR: out of memory
Date
Msg-id 8023.1265688603@sss.pgh.pa.us
Whole thread Raw
In response to Re: vacuumdb ERROR: out of memory  (David Kerr <dmk@mr-paradox.net>)
Responses Re: vacuumdb ERROR: out of memory
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: "Wang, Mary Y"
Date:
Subject: How do I drop a CONSTRAINT TRIGGER?
Next
From: David Kerr
Date:
Subject: Re: vacuumdb ERROR: out of memory