Skip site navigation (1) Skip section navigation (2)

patch: streaming of bytea parameter values

From: Oliver Jowett <oliver(at)opencloud(dot)com>
To: "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org>
Subject: patch: streaming of bytea parameter values
Date: 2004-04-21 04:02:34
Message-ID: 4085F25A.8060009@opencloud.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
This patch allows bytea parameters set via setBytes() / 
setBinaryStream() to be streamed to the backend. With the patch applied, 
the additional memory overhead for bytea parameters is small and 
independent of how large the parameter data is.

Note that it doesn't touch the ResultSet path, so you'll still need a 
pile of extra memory if you execute queries that return large bytea values.

It passes the driver's testcases against a 7.4 server, and doesn't show 
any problems after brief testing with our bytea-using application. I've 
had a report of strange things happening on the server->client path, but 
don't have any details at the moment.

This needs testing under a real workload, and testing against a 7.3 
server (the V2 protocol path is currently untested). Any volunteers?

-O

Attachment: pgjdbc-streaming-bytea.txt
Description: text/plain (13.5 KB)

Responses

pgsql-jdbc by date

Next:From: Edoardo CeccarelliDate: 2004-04-21 07:05:49
Subject: Re: looking for brave souls to test postgres java procedural
Previous:From: Oliver JowettDate: 2004-04-20 23:48:37
Subject: Re: Out of memory exception

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group