Vacuum analyse after a long time without one ...

From: Nicolas Michel <nicolas(dot)michel(at)lemail(dot)be>
To: pgsql-admin(at)postgresql(dot)org
Subject: Vacuum analyse after a long time without one ...
Date: 2009-09-11 11:33:40
Message-ID: 4AAA3594.7050900@lemail.be
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.

Is there a way to recover/vacuum this database? Is there an option in
the postgresql.conf that I can change?

Thanks a lot,
nm.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2009-09-11 14:10:34 Re: Vacuum analyse after a long time without one ...
Previous Message Kevin Kempter 2009-09-11 03:59:22 sql to show tablespace for indexes