Performance down with JDBC 42
От | Abraham, Danny |
---|---|
Тема | Performance down with JDBC 42 |
Дата | |
Msg-id | PH0PR02MB744665C3C2C73A828B42D9988EA4A@PH0PR02MB7446.namprd02.prod.outlook.com обсуждение исходный текст |
Ответ на | Re: Postgres Locking (Tom Lane <tgl@sss.pgh.pa.us>) |
Ответы |
Re: Performance down with JDBC 42
Performance problems with Postgres JDBC 42.4.2 |
Список | 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
В списке pgsql-performance по дате отправления: