pgjdbc/pgjdbc GitHub issues and pull requests (mirror)
help / color / mirror / Atom feedFrom: labkey-adam (@labkey-adam) <[email protected]>
To: pgjdbc/pgjdbc <[email protected]>
Subject: Re: [pgjdbc/pgjdbc] issue #3505: Metadata queries are much slower after update to 24.7.5
Date: Mon, 23 Jun 2025 19:25:54 +0000
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
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
view thread (25+ 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 #3505: Metadata queries are much slower after update to 24.7.5
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