Thread: Question regarding VACUUM ANALYZE ERROR . . .

Question regarding VACUUM ANALYZE ERROR . . .

From
"Peter E. Chen"
Date:
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 . . .

From
Tom Lane
Date:
"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