Postgres Pro
Downloads
Home   >   mailing lists

Performance down with JDBC 42 - Mailing list pgsql-performance

From Abraham, Danny
Subject Performance down with JDBC 42
Date
Msg-id PH0PR02MB744665C3C2C73A828B42D9988EA4A@PH0PR02MB7446.namprd02.prod.outlook.com
Whole thread Raw
In response to Re: Postgres Locking  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Performance down with JDBC 42  (Laurenz Albe <laurenz.albe@cybertec.at>)
Performance problems with Postgres JDBC 42.4.2  (Jose Osinde <jose.osinde@gmail.com>)
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Postgres Locking
Next
From: Laurenz Albe
Date:
Subject: Re: Performance down with JDBC 42