Nicolas Michel <nicolas.michel@xxxxxxxxx> writes: > I have a problem with a database. The last full vacuum analyse was made > long time ago... So I tried to start launching a vacuum analyse and I > get this error : > $ vacuumdb -az > vacuumdb: vacuuming database "postgres" > VACUUM > vacuumdb: vacuuming database "mexi" > vacuumdb: vacuuming of database "mexi" failed: ERROR: out of memory > DETAIL: Failed on request of size 134697600. What is your maintenance_work_mem setting? It rather looks like it's more than your system will really allow. regards, tom lane -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin