From: | David Durham <ddurham(at)vailsys(dot)com> |
---|---|
To: | Kris Jurka <books(at)ejurka(dot)com> |
Cc: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: streaming access to bytea data |
Date: | 2006-03-18 00:27:10 |
Message-ID: | 441B53DE.50909@vailsys.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Kris Jurka wrote:
> On Fri, 17 Mar 2006, David Durham wrote:
>
>> 1 - Does Postgres server load the entire bytea column before sending
>> to clients?
>
> Yes.
ok
> 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?
Thanks for the quick response, and the exact information that I needed.
Unfortunately large objects don't work with Slony replication.
Thanks again,
Dave
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Madu | 2006-03-18 13:00:33 | HowTo change keyStore location and KeyStore Password |
Previous Message | Kris Jurka | 2006-03-18 00:21:57 | Re: streaming access to bytea data |