Re: The performance issues caused by upgrading PostgreSQL to version 16.3.

Поиск
Список
Период
Сортировка
От Greg Sabino Mullane
Тема Re: The performance issues caused by upgrading PostgreSQL to version 16.3.
Дата
Msg-id CAKAnmm+eSi+M6UevXJh6WH=yToNYD+fqVvBb7YsZ7u_=tKRtDA@mail.gmail.com
обсуждение исходный текст
Ответ на The performance issues caused by upgrading PostgreSQL to version 16.3.  (馬 騰飛 <ma-tengfei@nec.cn>)
Ответы Re: The performance issues caused by upgrading PostgreSQL to version 16.3.
Список pgsql-general
On Mon, Feb 17, 2025 at 2:55 AM 馬 騰飛 <ma-tengfei@nec.cn> wrote:
Interestingly, when we isolate the problematic SQL statement and replace its parameters with actual values, it executes in just a few seconds in pgAdmin.
However, when we run the same SQL query through our application using Npgsql, it takes over ten minutes to complete.

Another reason could be a poor type casting by your driver/middleware. Can you share the query that is problematic? (also, since you mentioned a version upgrade, also make sure you run ANALYZE; post-upgrade.)

Cheers,
Greg

--
Enterprise Postgres Software Products & Tech Support

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