Re: Seeing high query planning time on Azure Postgres Single Server version 11.

Поиск
Список
Период
Сортировка
От Ron Johnson
Тема Re: Seeing high query planning time on Azure Postgres Single Server version 11.
Дата
Msg-id CANzqJaBUjo6gNy-m9ymWMq=5-7ed09D2jT8fX5UvMmu1Lu9rRA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Seeing high query planning time on Azure Postgres Single Server version 11.  (Greg Sabino Mullane <htamfids@gmail.com>)
Ответы Re: Seeing high query planning time on Azure Postgres Single Server version 11.
Список pgsql-general
On Sun, Mar 10, 2024 at 1:34 PM Greg Sabino Mullane <htamfids@gmail.com> wrote:

On Sat, Mar 9, 2024 at 1:57 PM hassan rafi <haassaan.khann@gmail.com> wrote:
Would upgrading to the latest version of Postgres potentially solve the issue?

Potentially, yes, but the only one who can answer that for sure is you. Upgrade to 11.22 and re-run the query. Worst case scenario, it runs the same speed but you gained yourself a bunch of bugfixes and CVE resolutions. If the problem persists on 11.22, spin up a Postgres 16, load the data, and test it there.

We have a similar situation with 9.6.24.  14.10 is noticeably faster (between 10% and 80%, depending on the query.

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

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: Question related to partitioning with pg_partman
Следующее
От: sud
Дата:
Сообщение: Re: Question related to partitioning with pg_partman