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

Поиск
Список
Период
Сортировка
От Nicolas Michel
Тема Re: Vacuum analyse after a long time without one ...
Дата
Msg-id 4AAA6EA0.8070501@lemail.be
обсуждение исходный текст
Ответ на Re: Vacuum analyse after a long time without one ...  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Vacuum analyse after a long time without one ...  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Vacuum analyse after a long time without one ...  (Lewis Kapell <lkapell@setonhome.org>)
Re: Vacuum analyse after a long time without one ...  ("Plugge, Joe R." <JRPlugge@west.com>)
Список pgsql-admin
Tom Lane a écrit :
> 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
>
I already tried to set the work_mem setting to the max value I can but
it changed nothing.

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

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