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

Mikko,

Thanks for the support, adding a DNS to the server's IP address in my hosts file solved it, but I'm curious, since I was directly using my server's IP address in the connection string, there shouldn't be any DNS requests at all. What am I missing?

About your suggestions I agree with Dave Cramer, although using Java 7 it's not a problem for me. The best solution would be number 1.

Thanks again.

Em quinta-feira, 18 de outubro de 2012 06h17min30s UTC-3, Mikko Tiihonen escreveu:
> 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
>
> ________________________________________
>
> From: pgsql-jdbc-owner(at)postgresql(dot)org [pgsql-jdbc-owner(at)postgresql(dot)org] on behalf of Craig Ringer [ringerc(at)ringerc(dot)id(dot)au]
>
> Sent: 18 October 2012 12:03
>
> To: S�rgio Saquetim
>
> Cc: pgsql-jdbc(at)postgresql(dot)org; Rafael dos Santos Silva
>
> Subject: Re: [JDBC] Severe performance degradation when using the 9.2-1000 JDBC 4 driver
>
>
>
> On 10/18/2012 12:16 PM, S�rgio Saquetim wrote:
>
> > I can confirm the problem, it's taking about 4000ms to get a Connection.
>
>
>
> That sounds like a broken DNS or reverse DNS setup in your environment,
>
> it's about right for your average DNS timeout.
>
>
>
> --
>
> Craig Ringer
>
>
>
>
>
> --
>
> Sent via pgsql-jdbc mailing list (pgsql-jdbc(at)postgresql(dot)org)
>
> To make changes to your subscription:
>
> http://www.postgresql.org/mailpref/pgsql-jdbc
>
>
>
>
>
> --
>
> Sent via pgsql-jdbc mailing list (pgsql-jdbc(at)postgresql(dot)org)
>
> To make changes to your subscription:
>
> http://www.postgresql.org/mailpref/pgsql-jdbc