Well, isn't it a bit crazy that bytea is the default JDBC BLOB type given the performance issues shown?
The general public that start to pump binary data into a PostgreSQL database are going to be confused if performance is
thatbad... and that was a grunty server too with bulkloads of RAM, I shudder to think what'd happen to a client.
I mean, generally if you're storing binary data it is for things such as image or document storage (of course there's
many,many other purposes), so the binary data wil be large.
Joe
> -----Original Message-----
> From: Dave Cramer [mailto:Dave@micro-automation.net]
> Sent: Wednesday, 17 April 2002 21:29
> To: Joe Shevland
> Cc: pgsql-jdbc@postgresql.org
> Subject: Re: [JDBC] BLOB performance test FYI
>
>
> Joe,
>
> Yes, Barry has commented on the reasons for this recently. The short
> version is that when you are using bytea, the backend parses the input.
>
> Dave