Re: Severe performance degradation when using the 9.2-1000 JDBC 4 driver - Mailing list pgsql-jdbc

From emergency.shower@gmail.com
Subject Re: Severe performance degradation when using the 9.2-1000 JDBC 4 driver
Date
Msg-id CACLs3uB7d=ff3NpDznJ40t5oa9FBq28qXVWpmCK7W_tfx=BMYg@mail.gmail.com
Whole thread Raw
In response to Re: Severe performance degradation when using the 9.2-1000 JDBC 4 driver  (Kris Jurka <books@ejurka.com>)
Responses Re: Severe performance degradation when using the 9.2-1000 JDBC 4 driver
List pgsql-jdbc
Hi Kris,

On Sat, Oct 6, 2012 at 2:43 AM, Kris Jurka <books@ejurka.com> wrote:
>
> Can you show us the connection URL that you are using?

Other as stated before, only connection URLs with IPv4 Addresses were
involved in our tests.

>  Are you using SSL?

No SSL.

> It appears that some of the 9.2 changes may require a DNS lookup that they
> didn't before and you might be getting a timeout there.  Any DNS issues on
> your side?

Actually there are two distinct problems:

 - a reverse lookup failure with a subdomain in the local network that
contains some of the test hosts, and

 - a reverse lookup failure with hosts that are located in our DMZ.

The first seems to be repairable to me, for the second I don't know.


-Alex


pgsql-jdbc by date:

Previous
From: Péter Kovács
Date:
Subject: Re: getMetaData().getUserName() implementation
Next
From: "emergency.shower@gmail.com"
Date:
Subject: Re: Severe performance degradation when using the 9.2-1000 JDBC 4 driver