Question regarding VACUUM ANALYZE ERROR . . .
Started by Peter E. Chenabout 24 years ago2 messagesgeneral
Hey All,
After running VACUUM ANALYZE, I get the following error:
ERROR: Memory exhausted in AllocSetAlloc(287033932)
Does anyone know what this means?
Peter
Re: Question regarding VACUUM ANALYZE ERROR . . .
"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