Question regarding VACUUM ANALYZE ERROR . . .

Started by Peter E. Chenabout 24 years ago2 messagesgeneral
Jump to latest
#1Peter E. Chen
pchen3@jhmi.edu

Hey All,

After running VACUUM ANALYZE, I get the following error:

ERROR: Memory exhausted in AllocSetAlloc(287033932)

Does anyone know what this means?

Peter

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Peter E. Chen (#1)
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