Re: vacuumdb ERROR: out of memory

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