Postgres Pro
Downloads
Home   >   mailing lists

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

From Ron Johnson
Subject Re: Seeing high query planning time on Azure Postgres Single Server version 11.
Date
Msg-id CANzqJaBUjo6gNy-m9ymWMq=5-7ed09D2jT8fX5UvMmu1Lu9rRA@mail.gmail.com
Whole thread Raw
In response to Re: Seeing high query planning time on Azure Postgres Single Server version 11.  (Greg Sabino Mullane <htamfids@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
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: Adrian Klaver
Date:
Subject: Re: Question related to partitioning with pg_partman
Next
From: sud
Date:
Subject: Re: Question related to partitioning with pg_partman