BUG #17467: Perf degradation after switching to latest jdbc drivers

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: benleis1(at)gmail(dot)com
Subject: BUG #17467: Perf degradation after switching to latest jdbc drivers
Date: 2022-04-21 18:15:33
Message-ID: 17467-84ec51d124f40fa0@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-jdbc

The following bug has been logged on the website:

Bug reference: 17467
Logged by: Benjamin Leis
Email address: benleis1(at)gmail(dot)com
PostgreSQL version: 13.4
Operating system: Linux
Description:

Due to the CVE-2022-21724 we upgraded our driver from 42.2.22 to 43.3.3.
We've now started to a large perf degradation during initial opens to the
database.

With a small perf test that just opens and tries a "select 1" we're getting
a ~2 - 2.5x slowdown on the connect times. Is this a known issue or
something that we can work around?

43.2.25 driver
INFO - New connection test
INFO - Open time: 25.00 Call time: 14.00
INFO - Open time: 24.00 Call time: 1.00
INFO - Open time: 19.00 Call time: 1.00
INFO - Open time: 16.00 Call time: 1.00
INFO - Open time: 26.00 Call time: 4.00
INFO - Open time: 20.00 Call time: 6.00
INFO - Open time: 20.00 Call time: 1.00
INFO - Open time: 16.00 Call time: 0.00
INFO - Open time: 19.00 Call time: 1.00
INFO - Open time: 19.00 Call time: 1.00

43.3.3 driver
INFO - New connection test
INFO - Open time: 57.00 Call time: 14.00
INFO - Open time: 58.00 Call time: 1.00
INFO - Open time: 62.00 Call time: 1.00
INFO - Open time: 54.00 Call time: 1.00
INFO - Open time: 59.00 Call time: 1.00
INFO - Open time: 56.00 Call time: 0.00
INFO - Open time: 59.00 Call time: 1.00
INFO - Open time: 61.00 Call time: 1.00
INFO - Open time: 57.00 Call time: 1.00
INFO - Open time: 58.00 Call time: 1.00

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message John Honarvar 2022-04-22 15:32:16 Is this a known Bug?
Previous Message Andres Freund 2022-04-21 16:17:10 Re: BUG #17401: REINDEX TABLE CONCURRENTLY creates a race condition on a streaming replica

Browse pgsql-jdbc by date

  From Date Subject
Next Message Jakub Wartak 2022-04-22 14:06:10 Why does the prepareThreshold=0 (to cover pgbouncer transaction mode) disables protocol binary transfers ? (w/ PoC patch and measurements)
Previous Message Olivier Bourgain 2022-04-21 10:56:50 [pgjdbc/pgjdbc] ffda18: docs: fix readme.md after #2495 (#2496)