Re: [EXTERNAL] Re: Performance down with JDBC 42

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: [EXTERNAL] Re: Performance down with JDBC 42
Дата
Msg-id CAMkU=1xSq_v1SvUGKpLzHCpvJ6PF3QnmFOx53+2h4zSvj_AFfQ@mail.gmail.com
обсуждение исходный текст
Ответ на RE: [EXTERNAL] Re: Performance down with JDBC 42  ("Abraham, Danny" <danny_abraham@bmc.com>)
Ответы RE: [EXTERNAL] Re: Performance down with JDBC 42  ("Abraham, Danny" <danny_abraham@bmc.com>)
Список pgsql-performance
On Sun, Nov 5, 2023 at 11:20 AM Abraham, Danny <danny_abraham@bmc.com> wrote:
Thanks Laurenz,

Traced two huge plans. They differ.
The fast one does use Materialize and Memoize  (the psql).
Is there something in JDBC 42 that blocks these algoruthms?

Directly blocking those is not likely. Maybe the way the drivers fetch partial results is different, such that with one the planner knows to expect only partial results to be fetched and with the other it does not.  So in one case it chooses the fast-start plan, and in the other it doesn't.  But it will be hard to get anywhere if you just dribble information at us a bit at a time.  Can you come up with a self-contained test case?  Or at least show the entirety of both plans?

Cheers,

Jeff

В списке pgsql-performance по дате отправления:

Предыдущее
От: Frits Hoogland
Дата:
Сообщение: Re: [EXTERNAL] Re: Performance down with JDBC 42
Следующее
От: "Abraham, Danny"
Дата:
Сообщение: RE: [EXTERNAL] Re: Performance down with JDBC 42