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  (Laurenz Albe <laurenz.albe@cybertec.at>)
Performance problems with Postgres JDBC 42.4.2  (Jose Osinde <jose.osinde@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Postgres Locking
Следующее
От: Laurenz Albe
Дата:
Сообщение: Re: Performance down with JDBC 42