Postgres Pro
Downloads
Home   >   mailing lists

Vacuum analyse after a long time without one ... - Mailing list pgsql-admin

From Nicolas Michel
Subject Vacuum analyse after a long time without one ...
Date
Msg-id 4AAA3594.7050900@lemail.be
Whole thread Raw
Responses Re: Vacuum analyse after a long time without one ...  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Tree view 
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.

pgsql-admin by date:

Previous
From: Kevin Kempter
Date:
Subject: sql to show tablespace for indexes
Next
From: Tom Lane
Date:
Subject: Re: Vacuum analyse after a long time without one ...