Re: BUG #2510: ERROR: out of memory DETAIL: Failed on request of size 825242672. - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #2510: ERROR: out of memory DETAIL: Failed on request of size 825242672.
Date
Msg-id 7273.1151967179@sss.pgh.pa.us
Whole thread Raw
In response to BUG #2510: ERROR: out of memory DETAIL: Failed on request of size 825242672.  ("alex tsai" <alex_tsai@pisem.net>)
List pgsql-bugs
"alex tsai" <alex_tsai@pisem.net> writes:
> I'm having a trouble trying to insert a tuple.
> I'm getting this kind of error "ERROR:  out of memory DETAIL:  Failed on
> request of size 825242672".
> What could it be?

You haven't really provided enough info to let anyone help you, but
sometimes this sort of error is a symptom of corrupt data.  If you try
to pg_dump the table, does it work?

            regards, tom lane

pgsql-bugs by date:

Previous
From: Tomasz Ostrowski
Date:
Subject: query very slow when enable_seqscan=on
Next
From: Tom Lane
Date:
Subject: Re: query very slow when enable_seqscan=on