Tom Lane a écrit :
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
I already tried to set the work_mem setting to the max value I can but
it changed nothing.
--
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
