Postgres Pro
Downloads
Home   >   mailing lists

Re: Seeing high query planning time on Azure Postgres Single Server version 11. - Mailing list pgsql-general

From hassan rafi
Subject Re: Seeing high query planning time on Azure Postgres Single Server version 11.
Date
Msg-id CAMWcn_kjLsi_1NyDvXEJeydAhRYvvUHizpEKwLW4PHY-Eq7n5g@mail.gmail.com
Whole thread Raw
In response to Re: Seeing high query planning time on Azure Postgres Single Server version 11.  (Ron Johnson <ronljohnsonjr@gmail.com>)
Responses Re: Seeing high query planning time on Azure Postgres Single Server version 11.  (hassan rafi <haassaan.khann@gmail.com>)
List pgsql-general
Tree view
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 by date:

Previous
From: Ilya Basin
Date:
Subject: Re: Query plans not identical for `id in(1,2,3)` and `(id=1 or id=2 or id=3)`
Next
From: Masahiko Sawada
Date:
Subject: Re: walsender RAM increases by 500 MB while data is 80 MB