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

From: Dave Cramer <pg(at)fastcrypt(dot)com>
To: Mikko Tiihonen <Mikko(dot)Tiihonen(at)nitorcreations(dot)com>
Cc: Craig Ringer <ringerc(at)ringerc(dot)id(dot)au>, 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 09:24:47
Message-ID: CADK3HH+YygFujdTsStpNk3N_c+V=cngh_388gXTi-5LPJEfYtw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

On Thu, Oct 18, 2012 at 5:17 AM, Mikko Tiihonen
<Mikko(dot)Tiihonen(at)nitorcreations(dot)com> 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:
> 1) modify the code so that is uses reflection and if Java7 is detected it will use the no-lookup method
> 2) wait 4 months until Oracle drops Java6 support (Java6 was supposed to be EOL already few months back) and use the no-lookup variant
> 3) let the code stay as is and let users fix their dns servers
>
> -Mikko

Number 1 above is probably the best option. Even if Oracle EOL's Java6
we will still have to support it for a while. 3 is probably
indefensible.

Dave Cramer

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

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Sérgio Saquetim 2012-10-18 10:46:33 Re: Severe performance degradation when using the 9.2-1000 JDBC 4 driver
Previous Message Mikko Tiihonen 2012-10-18 09:17:15 Re: Severe performance degradation when using the 9.2-1000 JDBC 4 driver