Re: vacuumdb ERROR: out of memory

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: David Kerr <dmk(at)mr-paradox(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: vacuumdb ERROR: out of memory
Date: 2010-02-09 04:10:03
Message-ID: 8023.1265688603@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David Kerr 2010-02-09 04:25:50 Re: vacuumdb ERROR: out of memory
Previous Message Wang, Mary Y 2010-02-09 04:02:59 How do I drop a CONSTRAINT TRIGGER?