Re: BLOB performance test FYI

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 that bad... 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(at)micro-automation(dot)net]
> Sent: Wednesday, 17 April 2002 21:29
> To: Joe Shevland
> Cc: pgsql-jdbc(at)postgresql(dot)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