Tom Lane wrote:
David Kerr <dmk@xxxxxxxxxxxxxx> 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
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
