Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Sun, Mar 10, 2024 at 1:34 PM Greg Sabino Mullane <htamfids@xxxxxxxxx> wrote:

On Sat, Mar 9, 2024 at 1:57 PM hassan rafi <haassaan.khann@xxxxxxxxx> 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.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux