Re: Question regarding VACUUM ANALYZE ERROR . . . - Mailing list pgsql-general

From Tom Lane
Subject Re: Question regarding VACUUM ANALYZE ERROR . . .
Date
Msg-id 15039.1010610209@sss.pgh.pa.us
Whole thread Raw
In response to Question regarding VACUUM ANALYZE ERROR . . .  ("Peter E. Chen" <pchen3@jhmi.edu>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: Query planner isn't using my indices
Next
From: Stephan Szabo
Date:
Subject: Re: Query planner isn't using my indices