Postgres Pro
Downloads
Home   >   mailing lists

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

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

pgsql-general by date:

Previous
From: Justin Graf
Date:
Subject: Re: Order by and strings
Next
From: "Wang, Mary Y"
Date:
Subject: How do I drop a CONSTRAINT TRIGGER?