Re: streaming access to bytea data

On Fri, 17 Mar 2006, David Durham wrote:

> 1 - Does Postgres server load the entire bytea column before sending to
> clients?

Yes.

> Might not be the right list for the previous question, but I thought someone
> might know.
>
> 2 - Does the current postgres jdbc driver support streaming reads/writes of
> bytea columns?  I saw in the archives that someone submitted a patch for
> streaming writes, but I didn't see anything regarding reads.

The JDBC driver can stream the write to the server, but the server will
still read the entire stream before writing it to disk, so it's a client
only streaming.

> If the jdbc driver doesn't currently support streaming reads, are there any
> plans to add this feature?  Any particular technical hurdles?
>

The JDBC driver doesn't support streaming reads, nor does any other client
interface.  You would need to extend the frontend/backend protocol to
return some sort of pointer to the bytea reference rather than the whole
thing.  This will still require the server to store the whole bytea result
somewhere to allow it to be pointed to.

Perhaps you should think about using large objects instead of bytea?

Kris Jurka