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

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

Re: Binary tx format for an array?



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



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group