From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: benleis1@gmail.com
Subject: BUG #17467: Perf degradation after switching to latest jdbc drivers
Date: Thu, 21 Apr 2022 18:15:33 +0000
Message-ID: <17467-84ec51d124f40fa0@postgresql.org> (raw)
The following bug has been logged on the website:
Bug reference: 17467
Logged by: Benjamin Leis
Email address: benleis1@gmail.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
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: pgsql-bugs@postgresql.org
Cc: noreply@postgresql.org, pgsql-bugs@lists.postgresql.org, benleis1@gmail.com
Subject: Re: BUG #17467: Perf degradation after switching to latest jdbc drivers
In-Reply-To: <17467-84ec51d124f40fa0@postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox