Re: Binary tx format for an array? - Mailing list pgsql-jdbc

From Markus Schaber
Subject Re: Binary tx format for an array?
Date
Msg-id 449BD7C1.3050501@logix-tt.com
Whole thread Raw
In response to Re: Binary tx format for an array?  (Dave Cramer <pg@fastcrypt.com>)
List pgsql-jdbc
Hi, Dave,

Dave Cramer wrote:

> I'm curious. Are you attempting to implement the binary protocol for the
> jdbc driver ?
>
> If so, how are you dealing with date types which are either 64 bit or
> floating point.
>
> Have you done any testing to see if it is actually faster ?
>
> There's certainly no question with timestamp/date parsing, others may be
> questionable .

At least for PostGIS (which uses a hexed representation for text
protocol currently), I expect the data volume to be exactly 50% for binary.

Bytea and blobs may be similar.


Markus



--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf.     | Software Development GIS

Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org

pgsql-jdbc by date:

Previous
From: Dave Cramer
Date:
Subject: Re: Binary tx format for an array?
Next
From: "Michael Guyver"
Date:
Subject: Re: Binary tx format for an array?