Re: bytea performance tweak

From: Oliver Jowett <oliver(at)opencloud(dot)com>
To: Andreas Schmitz <schmitz(at)occamlabs(dot)de>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: bytea performance tweak
Date: 2011-06-21 23:59:07
Message-ID: BANLkTimryw=Sm5q4v53PQNkdi+RjAfgJBA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

On 22 June 2011 01:08, Andreas Schmitz <schmitz(at)occamlabs(dot)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

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Craig Ringer 2011-06-22 03:27:14 Re: bytea performance tweak
Previous Message Andreas Schmitz 2011-06-21 13:08:11 bytea performance tweak