pgjdbc/pgjdbc GitHub issues and pull requests (mirror)  

help / color / mirror / Atom feed

From: danielhasan (@danielhasan) <[email protected]>
To: pgjdbc/pgjdbc <[email protected]>
Subject: [pgjdbc/pgjdbc] issue #3511: Performance Regression in JDBC Driver 42.7.5 - getCrossReference
Date: Wed, 05 Feb 2025 14:14:13 +0000
Message-ID: <[email protected]> (raw)

I am reporting a performance issue encountered with the JDBC driver version 42.7.5 when using the getCrossReference method from the DatabaseMetaData interface. 

Issue:
In version 42.7.5, the execution time for getCrossReference has significantly increased. Specifically, the recovery time has gone from approximately 1 second in version 42.7.4 to 15 seconds when querying against a database with 450 tables.

Steps to Reproduce:

Use JDBC driver version 42.7.5.
Call the getCrossReference method on the DatabaseMetaData instance for a schema containing 450 tables.
Observe the time taken for the operation.
Expected Behavior:
The expected response time for the getCrossReference call using version 42.7.4 is approximately 1 second.

Actual Behavior:
The actual response time in version 42.7.5 has increased to approximately 15 seconds.

Environment:

JDBC Driver Version: 42.7.5
Previous Version (for Comparison): 42.7.4
Database Size: 450 tables
Recommendation:
Please investigate the performance degradation introduced in version 42.7.5 and consider reverting any changes that may have impacted the efficiency of the getCrossReference method.

Thank you for looking into this matter.

view thread (24+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: github://pgjdbc/pgjdbc
  Cc: [email protected], [email protected]
  Subject: Re: [pgjdbc/pgjdbc] issue #3511: Performance Regression in JDBC Driver 42.7.5 - getCrossReference
  In-Reply-To: <<[email protected]>>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox