Re: vacuumdb ERROR: out of memory

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 03:59:56
Message-ID: 4B70DDBC.5050408@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:
>> I'm getting error:
>> When I try
>> vacuumdb -z assessment
>> or
>> vacuumdb assessment
>
>> 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?
>
> regards, tom lane
>

maintenance_work_mem = 1GB

I don't know if it matters but my biggest relation is 7GB
(total including indexes is 16GB) with my total DB size being 20GB

Dave

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Wang, Mary Y 2010-02-09 04:02:59 How do I drop a CONSTRAINT TRIGGER?
Previous Message Justin Graf 2010-02-09 01:09:45 Re: Order by and strings