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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Vacuum analyse after a long time without one ...
Дата
Msg-id 19845.1252678234@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Vacuum analyse after a long time without one ...  (Nicolas Michel <nicolas.michel@lemail.be>)
Ответы Re: Vacuum analyse after a long time without one ...  (Nicolas Michel <nicolas.michel@lemail.be>)
Список pgsql-admin
Nicolas Michel <nicolas.michel@lemail.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

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

Предыдущее
От: Nicolas Michel
Дата:
Сообщение: Vacuum analyse after a long time without one ...
Следующее
От: Nicolas Michel
Дата:
Сообщение: Re: Vacuum analyse after a long time without one ...