Re: Speed up JDBC connection creation on 9.0+

From: Sehrope Sarkuni <sehrope(at)jackdb(dot)com>
To: Gavin Flower <GavinFlower(at)archidevsys(dot)co(dot)nz>, List <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: Speed up JDBC connection creation on 9.0+
Date: 2014-04-19 00:18:21
Message-ID: CAH7T-ao=OHhc5vghyKqLHufa8c-2x_DtsfkMOBdYsmPDDtPpig@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

On Fri, Apr 18, 2014 at 7:56 PM, Gavin Flower
<GavinFlower(at)archidevsys(dot)co(dot)nz> wrote:
> What happens when we get an even more Modern Server?

Well we could use "isModernerServer" and "isModernestServer" each at
least once ...

> How about 'is9.0PlusServer', or something like it?

Yes something like that would be better.

Alternatively how about specifying the minimum expected server version
(say "minServerVersion")? That should be fairly future proof. The
driver could even throw an exception if the server version isn't
compatible when it receives the "server_version" ParameterStatus on
init.

What do you guys think of not doing anything now and instead having
this behavior be the default in the next version of the driver?

As much as I like having a connection property to set now, I'd much
prefer to just get this "for free" by upgrading to a newer driver
without changing JDBC urls. If everybody will be assumed to be running
9.0+ (after 8.4 is EOL) then it's a bit annoying to have to add the
connection property everywhere to get this.

Regards,
-- Sehrope Sarkuni
Founder & CEO | JackDB, Inc. | http://www.jackdb.com/

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Gavin Flower 2014-04-19 03:33:37 Re: Speed up JDBC connection creation on 9.0+
Previous Message Gavin Flower 2014-04-18 23:56:21 Re: Speed up JDBC connection creation on 9.0+