If this is test then do thorough testing. Also, if you want to run temporarily then why not retains same OS and PG release? If query is behaving differently take an explain plan for it and check the cost of the query. Also, try to re-create indexes for that query table and analyze the table as well. Check the compatibility matrix for PG and RHEL releases.
On Thu, Jun 27, 2024 at 10:39 PM Wasim Devale <wasimd60@gmail.com> wrote:
Hi All
So I used postgresql 13 installed on RHEL 9.
It is restored from postgresql 12.8 running on CentOS7.
We ran into an issue with only one query that took a long time to run 4 hours whereas it was taking 20 mins to run on postgresql 12.8 why this difference other queries are working fine.
Note: postgis and pgrouting extension is installed on both.
All your questions will be answered if you read them.
On Wed, Jun 26, 2024 at 2:34 AM Wasim Devale <wasimd60@gmail.com> wrote:
Thanks I do not have an understanding of the app and Java application which we have and our manager is not comfortable to have this plan you mentioned.
1. Did you read the links I sent you? Your question seems to indicate that you didn't.
2. What makes you think that PG16 is sooooooo different from PG 12 that your "old fashioned app" won't run on it? That's just silly.
(We just migrated PG 9.6 databases on RHEL6 to PG 14 on RHEL8. The old applications did not change. Only the JDBC driver needed updating.)
On Wed, Jun 26, 2024 at 2:21 AM Wasim Devale <wasimd60@gmail.com> wrote:
Thanks
We have an old fashioned app we need to upgrade everything but for a time being 1 or 2 months can I use postgresql 12.19 on RHEL 9 so that the application's behaviour and old construction SQL queries will match with it ?
