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

From: Merlin Moncure <mmoncure(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Oliver Jowett <oliver(at)opencloud(dot)com>, Mikko Tiihonen <mikko(dot)tiihonen(at)nitorcreations(dot)com>, pgsql-jdbc(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org
Subject: Re: [JDBC] Optimize postgres protocol for fixed size arrays
Date: 2011-11-23 16:07:18
Message-ID: CAHyXU0yVXyVNBHe56Rx9VUC8NHfLN=naYokfoPLPMtUH=XCyjA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-jdbc

On Tue, Nov 22, 2011 at 6:52 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Oliver Jowett <oliver(at)opencloud(dot)com> writes:
>> On 23 November 2011 10:47, Mikko Tiihonen
>> <mikko(dot)tiihonen(at)nitorcreations(dot)com> wrote:
>>> Here is a patch that adds a new flag to the protocol that is set when all
>>> elements of the array are of same fixed size.
>
>> How does a client detect that this feature is supported?
>
> The only way that anything like this will go in is as part of a protocol
> version bump, so discoverability would reduce to knowing which protocol
> you're using.  We should file this away as one of the things we might
> want to do whenever there's sufficient critical mass for a new wire
> protocol version.
>
> Note that COPY BINARY files would be affected too, and so we'd want to
> make sure that this sort of change is recognizable from a binary file's
> header.

Wire format changes can only be made with a protocol version bump? Is
this a new policy? In the past they were just made...for example the
money type was bumped to 64 bits. In the past it was always buyer
beware for binary format consumers.

merlin

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Simon Riggs 2011-11-23 16:14:04 Re: Not HOT enough
Previous Message Tom Lane 2011-11-23 16:03:10 Re: Permissions checks for range-type support functions

Browse pgsql-jdbc by date

  From Date Subject
Next Message Tom Lane 2011-11-23 16:36:28 Re: [JDBC] Optimize postgres protocol for fixed size arrays
Previous Message Tom Lane 2011-11-22 23:52:24 Re: [JDBC] Optimize postgres protocol for fixed size arrays