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.
