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

pgsql-general by date:

Previous
From: Fredric Fredricson
Date:
Subject: Order by and strings
Next
From: Justin Graf
Date:
Subject: Re: Order by and strings