Performance down with JDBC 42
Abraham, Danny <danny_abraham@bmc.com>
From: "Abraham, Danny" <danny_abraham@bmc.com>
To: psql-performance <pgsql-performance@postgresql.org>
Cc: "Abraham, Danny" <danny_abraham@bmc.com>
Date: 2023-11-04T19:08:22Z
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