Re: Severe performance degradation when using the 9.2-1000 JDBC 4 driver

From: Dave Cramer <pg(at)fastcrypt(dot)com>
To: Craig Ringer <ringerc(at)ringerc(dot)id(dot)au>
Cc: Mikko Tiihonen <Mikko(dot)Tiihonen(at)nitorcreations(dot)com>, Sérgio Saquetim <sergiosaquetim(at)gmail(dot)com>, "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org>, Rafael dos Santos Silva <xfalcox(at)gmail(dot)com>
Subject: Re: Severe performance degradation when using the 9.2-1000 JDBC 4 driver
Date: 2012-10-18 12:43:15
Message-ID: CADK3HH+QvASPUKaSgiYCPqVzYFtoY+5HYBLjg0NgwazJK_CK2Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

On Thu, Oct 18, 2012 at 8:18 AM, Craig Ringer <ringerc(at)ringerc(dot)id(dot)au> wrote:
> On 10/18/2012 05:17 PM, Mikko Tiihonen wrote:
>>
>> I think the DNS lookup is part of the JDBC failover connection patch that
>> I created.
>> I initially used a InetSocketAddress.getHostString() that does not do any
>> DNS lookups, but since that method was added in Java7 I had to revert to
>> getHostName() method which does.
>>
>> I see following options:
>
>
> 0) Revert the JDBC failover patch or require a connection parameter to
> enable it
>
>
>> 1) modify the code so that is uses reflection and if Java7 is detected it
>> will use the no-lookup method
>
>
> Gah! no! Not only will this not work in most SecurityManager contexts, but
> it's slow and horrid.

Surely there must be a way to detect that you are on Java7 without reflection ?

Dave Cramer

dave.cramer(at)credativ(dot)ca
http://www.credativ.ca

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Craig Ringer 2012-10-18 12:48:41 Re: Severe performance degradation when using the 9.2-1000 JDBC 4 driver
Previous Message Craig Ringer 2012-10-18 12:18:42 Re: Severe performance degradation when using the 9.2-1000 JDBC 4 driver