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

FWIW,

I released 42.2.25 to address this issue as well. PostgreSQL JDBC Changelog
<https://jdbc.postgresql.org/documentation/changelog.html#version_42.2.25>

<https://jdbc.postgresql.org/documentation/changelog.html#version_42.2.25>However
it would be nice to see your test code so that I can verify.

Regards,

Dave Cramer
www.postgres.rocks

On Mon, 25 Apr 2022 at 12:58, Benjamin Leis <benleis1(at)gmail(dot)com> wrote:

>
> 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
>
>