From: | Benjamin Leis <benleis1(at)gmail(dot)com> |
---|---|
To: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Fwd: BUG #17467: Perf degradation after switching to latest jdbc drivers |
Date: | 2022-04-25 16:58:15 |
Message-ID: | CADP9qHvLD53E-Ff4dh8f0WGCz+HS_CHHgt08+AHXOZQCFXHj4g@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs pgsql-jdbc |
Forwarding this to the jdbc list.
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 see 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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2022-04-25 19:03:32 | Re: 14.1 immutable function, bad performance if check number = 'NaN' |
Previous Message | Bruce Momjian | 2022-04-25 15:14:45 | Re: Is this a known Bug? |
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Dunstan | 2022-04-25 20:08:45 | Re: Why does the prepareThreshold=0 (to cover pgbouncer transaction mode) disables protocol binary transfers ? (w/ PoC patch and measurements) |
Previous Message | Tom Lane | 2022-04-25 13:36:12 | Re: BUG #17467: Perf degradation after switching to latest jdbc drivers |