Message-ID: <gh-pgjdbc-pgjdbc-3505-c2997699303@github.com>
From: "labkey-adam (@labkey-adam)" <noreply+labkey-adam@github.com>
To: "pgjdbc/pgjdbc" <noreply+pgjdbc-pgjdbc@github.com>
Date: Mon, 23 Jun 2025 19:25:54 +0000
Subject: Re: [pgjdbc/pgjdbc] issue #3505: Metadata queries are much slower after update to 24.7.5
In-Reply-To: <gh-pgjdbc-pgjdbc-3505@github.com>
References: <gh-pgjdbc-pgjdbc-3505@github.com>
List-Id: <gh-pgjdbc-pgjdbc.github.com>
X-GitHub-Author-Login: labkey-adam
X-GitHub-Comment-Id: 2997699303
X-GitHub-Comment-Type: issue_comment
X-GitHub-Edited-At: 2025-06-23T22:42:56Z
X-GitHub-Issue: 3505
X-GitHub-Repo: pgjdbc/pgjdbc
X-GitHub-Type: comment
X-GitHub-Url: https://github.com/pgjdbc/pgjdbc/issues/3505#issuecomment-2997699303
Content-Type: text/plain; charset=utf-8

Local testing of the current 42.7.7-SNAPSHOT driver shows a significant improvement in the performance of `getImportedKeys()`. While still 47% slower than 42.7.4, it's definitely a huge improvement over 42.7.5 and 42.7.6.

Average query time for getImportedKeys() on my local machine (in all cases >1,100 invocations across a wide variety of tables in many schemas):

| Version|Average Invocation Time|
|--------|--------|
| 42.7.7-SNAPSHOT|14.4ms|
| 42.7.6|88.5ms|
| 42.7.4|9.8ms|

My absolute times differ from what my colleague @labkey-tchad reported initially (different environments), but I see similar order of magnitude degradation in performance with the recent releases. It would be nice to get back below 10ms on average, but the SNAPSHOT shows enough improvement that we'll no longer be blocked from upgrading. We look forward to an official release of 42.7.8.

Thanks for all your work on this important piece of software!

Adam