On Fri, 1 Jul 2005, [UTF-8] ^Y^B^\^_ ^\ wrote:
>
> I got a web application that use jdbc and that will need to stream
> binary data to the database.
>
> My application need an outputstream to send the data to the db, and
> an inputstream to read the data from the db.
>
> I use postgresql 8.0.1 with bytea field.
>
> >100mb 20%
>
If you are really dealing with 100+Mb files you should probably look into
using large objects instead of bytea storage. This will provide the
streaming interfaces you are looking for and avoid excessive memory usage.
http://jdbc.postgresql.org/documentation/80/binary-data.html
Kris Jurka