Re: bytea performance tweak - Mailing list pgsql-jdbc

From Oliver Jowett
Subject Re: bytea performance tweak
Date
Msg-id BANLkTimryw=Sm5q4v53PQNkdi+RjAfgJBA@mail.gmail.com
Whole thread Raw
In response to bytea performance tweak  (Andreas Schmitz <schmitz@occamlabs.de>)
Responses Re: bytea performance tweak  (Craig Ringer <craig@postnewspapers.com.au>)
Re: bytea performance tweak  (Andreas Schmitz <schmitz@occamlabs.de>)
List pgsql-jdbc
On 22 June 2011 01:08, Andreas Schmitz <schmitz@occamlabs.de> wrote:
> Hi,
>
> I've noticed that fetching a bytea field produces a lot of overhead when
> converting into a byte[] or InputStream. Looking at the code, I've
> produced a small patch (a lookup table for the hex codes) which makes
> the conversion faster. What do you think?

Surprising. How did you benchmark it?

Oliver

pgsql-jdbc by date:

Previous
From: Andreas Schmitz
Date:
Subject: bytea performance tweak
Next
From: Craig Ringer
Date:
Subject: Re: bytea performance tweak