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

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

Tom Lane a écrit :
> 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
>
I already tried to set the work_mem setting to the max value I can but
it changed nothing.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2009-09-11 15:39:15 Re: Vacuum analyse after a long time without one ...
Previous Message Tom Lane 2009-09-11 14:10:34 Re: Vacuum analyse after a long time without one ...