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

From: Greg Sabino Mullane <htamfids(at)gmail(dot)com>
To: hassan rafi <haassaan(dot)khann(at)gmail(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Robert Treat <rob(at)xzilla(dot)net>, Ron Johnson <ronljohnsonjr(at)gmail(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Seeing high query planning time on Azure Postgres Single Server version 11.
Date: 2024-03-10 17:33:46
Message-ID: CAKAnmmK95PoyGxYjF01KhduA=6skv3c2Z36mGL2HcxF85ty3EQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Cheers,
Greg

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message sud 2024-03-10 17:51:42 Re: Question related to partitioning with pg_partman
Previous Message Adrian Klaver 2024-03-10 17:01:58 Re: Question related to partitioning with pg_partman