Re: Problem retrieving large records (bytea) data from a table

jtkells@verizon.net, 05.07.2011 18:44:
> A while ago the some developers inserted several records with a
> document (stored in doc_Data) that was around 400 - 450 MB each. Now
> when you do a select * (all) from this table you get a hang and the
> system becomes unresponsive.

What application/program is "hanging"? The client that retrieves the data or PostgreSQL itself?

> So I'm not sure how to find these bad records and why I am getting a
> hang.
If your client application is hanging, I don't think there is a single "bad" record, it just chokes on the size of the
resultset. 

Regards
Thomas