Re: Question regarding VACUUM ANALYZE ERROR . . .

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Question regarding VACUUM ANALYZE ERROR . . .
Дата
Msg-id 15039.1010610209@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Question regarding VACUUM ANALYZE ERROR . . .  ("Peter E. Chen" <pchen3@jhmi.edu>)
Список pgsql-general
"Peter E. Chen" <pchen3@jhmi.edu> writes:
> After running VACUUM ANALYZE, I get the following error:
> ERROR:  Memory exhausted in AllocSetAlloc(287033932)

Looks like corrupted data to me --- specifically, a variable-length
field with a garbage length word.  You would probably get the same
error from a SELECT * FROM the-affected-table.  With a little sleuth
work you might be able to identify and delete the broken row(s).

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Query planner isn't using my indices
Следующее
От: Stephan Szabo
Дата:
Сообщение: Re: Query planner isn't using my indices