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

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 (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-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

pgsql-hackers by date

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

pgsql-jdbc by date

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

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