I see only two possibilities
1. Decrease fetch size, e.g. to 1.
2. Refactor schema.
Kind regards,
Radek
On Wed, 24 Nov 2010 22:50:46 +0200, Александър Шопов
<lists@kambanaria.org>
wrote:
> Hi everyone,
> I have a table containing file contents in bytea columns.
> The functionality I am trying to achieve is having a result set
> containing such columns, iterating over them and streaming them while
> zipping them.
[...]
> So what am I options? Refactor the DB schema to use blobs rather than
> bytea? Is it impossible to have bytea read in chunks?
> Kind regards:
> al_shopov
--
----------
Radosław Smogura
http://www.softperience.eu
