Re: Vacuum analyse after a long time without one ...

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Nicolas Michel <nicolas(dot)michel(at)lemail(dot)be>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Vacuum analyse after a long time without one ...
Date: 2009-09-11 14:10:34
Message-ID: 19845.1252678234@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Nicolas Michel <nicolas(dot)michel(at)lemail(dot)be> 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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Nicolas Michel 2009-09-11 15:37:04 Re: Vacuum analyse after a long time without one ...
Previous Message Nicolas Michel 2009-09-11 11:33:40 Vacuum analyse after a long time without one ...