Performance down with JDBC 42

From: "Abraham, Danny" <danny_abraham(at)bmc(dot)com>
To: psql-performance <pgsql-performance(at)postgresql(dot)org>
Cc: "Abraham, Danny" <danny_abraham(at)bmc(dot)com>
Subject: Performance down with JDBC 42
Date: 2023-11-04 19:08:22
Message-ID: PH0PR02MB744665C3C2C73A828B42D9988EA4A@PH0PR02MB7446.namprd02.prod.outlook.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hi,

Asking for help with a JDBC related issue.
Environment: Linux 7.9 PG 14.9 , very busy PG Server.

A big query - 3 unions and about 10 joins runs :
- 70ms on psql , DBeaver with JDBC 42 and in our Server using old JDBC 9.2
- 2500 ms in our Server using new JDBC 42 driver. ( and this is running many times)

Question: Is there a structured way to identify optimization setup ( Planner Method s ) changes?
Are there any known changes specific to JDBC 42.
Capture a vector of session optimization setup?
Any other Idea ?

Thanks

Danny

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Laurenz Albe 2023-11-04 21:07:19 Re: Performance down with JDBC 42
Previous Message Tom Lane 2023-10-31 21:45:12 Re: Postgres Locking