Skip site navigation (1) Skip section navigation (2)

Re: bytea performance tweak

From: Andreas Schmitz <schmitz(at)occamlabs(dot)de>
To: Oliver Jowett <oliver(at)opencloud(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: bytea performance tweak
Date: 2011-06-23 10:06:16
Message-ID: 20110623100616.GA14152@summalogicae.occamlabs.local (view raw or flat)
Thread:
Lists: pgsql-jdbc
Oliver Jowett wrote:

Hi,

> On 23 June 2011 02:17, Andreas Schmitz <schmitz(at)occamlabs(dot)de> wrote:
> 
> > I was wondering why the protocol uses such an encoding anyway. Wouldn't
> > it be a lot faster just sending the bytes as they are?
> 
> We can request binary-format data, which for bytea is indeed just the
> raw bytes, but the problem is that it's all or nothing: if we request
> binary data we have to handle binary results for all datatypes, not
> just bytea (because the request is per-column and generally the driver
> doesn't know the column type at the point it makes the request)
> Some progress has been made with that, but it's not production-ready
> yet I think.

ok, understood. Is there a timeline for fully supporting the binary
protocol?

Best regards, Andreas

In response to

Responses

pgsql-jdbc by date

Next:From: Marc-André LaverdièreDate: 2011-06-27 06:18:12
Subject: Re: Support for cert auth in JDBC
Previous:From: Oliver JowettDate: 2011-06-22 23:23:41
Subject: Re: bytea performance tweak

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group