Re: Status of server side Large Object support?

Peter Eisentraut wrote:
> Am Sonntag, 28. November 2004 12:33 schrieb Thomas Hallgren:
>
>>Hmm, ok. But there's no way to stream them in and out from disk. From
>>what I can see, you have to bring all of it into memory. Not so ideal
>>perhaps if you want to provide streaming media for thousands of users.
>
>
> You can use the substring function to read the pieces you need.
>
Won't the substring function bring the whole thing into memory in the
backend before it pass you the piece you need? Let's assume I want to
stream 4k at a time of a 40mb image, that's a whole lot of byte swapping
if that's the case.

How do you handle writes without first creating the whole image in memory?

From what I can see, the current JDBC driver uses the lo_<xxx> client
api's and they seem to map to the inv_<xxx> server api's.

Regards,
Thomas Hallgren