Re: [JDBC] Optimize postgres protocol for fixed size arrays

From: Oliver Jowett <oliver(at)opencloud(dot)com>
To: Mikko Tiihonen <mikko(dot)tiihonen(at)nitorcreations(dot)com>
Cc: Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>, tgl(at)sss(dot)pgh(dot)pa(dot)us, mmoncure(at)gmail(dot)com, pgsql-hackers(at)postgresql(dot)org, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: [JDBC] Optimize postgres protocol for fixed size arrays
Date: 2011-11-25 00:20:02
Message-ID: CA+0W9LPw_pvsHF9sdpMO=V1A0UG496rdnEw5dNaG0WLG0zR-3A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-jdbc

On 25 November 2011 07:54, Mikko Tiihonen
<mikko(dot)tiihonen(at)nitorcreations(dot)com> wrote:

> <=BE ParameterStatus(binary_minor = 23)
> FE=> Execute(SET binary_minor = 20)

Yeah this was almost exactly what I was thinking about how to retrofit
it, except it might be clearer to have, say, "supported_binary_minor"
(read-only, advertised by the server on startup) vs. "binary_minor"
(read-write, defaults to 0) as otherwise you have special behavior for
just one parameter where the advertised version doesn't actually match
the currently-set version.

Re list vs. always-incrementing minor version, you could just use an
integer and set bits to represent features, which would keep it simple
but also let clients be more selective about which features they
implement (you could support feature 21 and 23 without supporting 22)

Oliver

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Geoghegan 2011-11-25 01:05:15 Re: Inlining comparators as a performance optimisation
Previous Message Thom Brown 2011-11-24 21:57:11 Re: [COMMITTERS] pgsql: Enable CHECK constraints to be declared NOT VALID

Browse pgsql-jdbc by date

  From Date Subject
Next Message Stevo Slavić 2011-11-25 02:57:23 Re: Publish 9.1-901 JDBC drivers on maven central
Previous Message Heikki Linnakangas 2011-11-24 19:40:30 Re: CallableStatement PostgreSQL Error:A CallableStatement was executed with an invalid number of parameters