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

Поиск
Список
Период
Сортировка
От hassan rafi
Тема Re: Seeing high query planning time on Azure Postgres Single Server version 11.
Дата
Msg-id CAMWcn_kjLsi_1NyDvXEJeydAhRYvvUHizpEKwLW4PHY-Eq7n5g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Seeing high query planning time on Azure Postgres Single Server version 11.  (Ron Johnson <ronljohnsonjr@gmail.com>)
Ответы Re: Seeing high query planning time on Azure Postgres Single Server version 11.
Список pgsql-general
Дерево обсуждения
Thanks all. Will try upgrading the postgres version.

On Sun, Mar 10, 2024 at 11:44 PM Ron Johnson <ronljohnsonjr@gmail.com> wrote:
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 по дате отправления:

Предыдущее
От: Ilya Basin
Дата:
Сообщение: Re: Query plans not identical for `id in(1,2,3)` and `(id=1 or id=2 or id=3)`
Следующее
От: Masahiko Sawada
Дата:
Сообщение: Re: walsender RAM increases by 500 MB while data is 80 MB