David Kerr <dmk@xxxxxxxxxxxxxx> writes: > Tom Lane wrote: >> David Kerr <dmk@xxxxxxxxxxxxxx> writes: >>> 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? > maintenance_work_mem = 1GB So evidently, when it tries to actually allocate 1GB, it can't do it. Ergo, that setting is too high for your machine. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
