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
wasdirectly using my server's IP address in the connection string, there shouldn't be any DNS requests at all. What am
Imissing? 

About your suggestions I agree with Dave Cramer, although using Java 7 it's not a problem for me. The best solution
wouldbe 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
addedin 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-lookupvariant 
>
> 3) let the code stay as is and let users fix their dns servers
>
>
>
> -Mikko
>
> ________________________________________
>
> From: pgsql-jdbc-owner@postgresql.org [pgsql-jdbc-owner@postgresql.org] on behalf of Craig Ringer
[ringerc@ringerc.id.au]
>
> Sent: 18 October 2012 12:03
>
> To: S�rgio Saquetim
>
> Cc: pgsql-jdbc@postgresql.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@postgresql.org)
>
> To make changes to your subscription:
>
> http://www.postgresql.org/mailpref/pgsql-jdbc
>
>
>
>
>
> --
>
> Sent via pgsql-jdbc mailing list (pgsql-jdbc@postgresql.org)
>
> To make changes to your subscription:
>
> http://www.postgresql.org/mailpref/pgsql-jdbc