Vacuum analyse after a long time without one ...

Поиск
Список
Период
Сортировка
От Nicolas Michel
Тема Vacuum analyse after a long time without one ...
Дата
Msg-id 4AAA3594.7050900@lemail.be
обсуждение исходный текст
Ответы Re: Vacuum analyse after a long time without one ...
Список 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.


В списке pgsql-admin по дате отправления:

Предыдущее
От: Kevin Kempter
Дата:
Сообщение: sql to show tablespace for indexes
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Vacuum analyse after a long time without one ...