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

Re: Status of binary protocol usage?

From: aaime74 <andrea(dot)aime(at)gmail(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Status of binary protocol usage?
Date: 2007-06-24 16:21:56
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-jdbc

Tom Lane-2 wrote:
> aaime74 <andrea(dot)aime(at)gmail(dot)com> writes:
>> A profiler informs me that quite a big of time is spent in the
>> PGBytea.toBytes(byte[]s) method, which is used only if the transfer
>> occurrs in text mode.
> That hardly seems like a killer argument for switching to binary
> (which has got a boatload of disadvantages of its own).  Surely a
> bit of code-optimization work can fix that.

Hum, interesting. What would be the boatload of disadvantages? Is there
any reference to those? 
Do you have any idea why doing more processing (Base64 encoding/decoding)
leads to significant better performance? :)


View this message in context:
Sent from the PostgreSQL - jdbc mailing list archive at

In response to


pgsql-jdbc by date

Next:From: Russell FrancisDate: 2007-06-24 16:52:04
Subject: Patch to improve Cloneable implementation on classes which extend PGobject.
Previous:From: Tom LaneDate: 2007-06-24 15:40:52
Subject: Re: Status of binary protocol usage?

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