Re: sql statement not using all primary key values and poor performance
От
Laurenz Albe
Тема
Re: sql statement not using all primary key values and poor performance
Дата
Msg-id
b35f429c57756a151f5b1bbc73b80f24249d75e7.camel@cybertec.at
Ответ на
Список
Дерево обсуждения
sql statement not using all primary key values and poor performance James Pang <jamespang886@gmail.com>
Re: sql statement not using all primary key values and poor performance Laurenz Albe <laurenz.albe@cybertec.at>
Re: sql statement not using all primary key values and poor performance James Pang <jamespang886@gmail.com>
Re: sql statement not using all primary key values and poor performance Laurenz Albe <laurenz.albe@cybertec.at>
Re: sql statement not using all primary key values and poor performance James Pang <jamespang886@gmail.com>
On Fri, 2024-02-23 at 18:21 +0800, James Pang wrote: > it's a third-party vendor application, not easy to change their code. Then the application is broken, and you should make the vendor fix it. > is it possible to 1) in Postgresql JDBC driver connection, set > plan_cache_mode=force_custom_plan or 2) some other parameters can workaround this issue? You can set "prepareThreshold" to 0 to keep the JDBC driver from using prepared statements in PostgreSQL. I am not sure if that is enough to fix the problem. Yours, Laurenz Albe
В списке pgsql-performance по дате отправления
От: James Pang
Дата:
