No I checked from developer
is that query using postgis related type?On Thu, Jun 27, 2024 at 10:39 PM Wasim Devale <wasimd60@xxxxxxxxx> wrote:Hi AllSo 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.
Thanks,
WasimOn Thu, 27 Jun, 2024, 9:22 pm Wasim Devale, <wasimd60@xxxxxxxxx> wrote:Thanks for the clarification.
On Wed, 26 Jun, 2024, 6:41 pm Ron Johnson, <ronljohnsonjr@xxxxxxxxx> wrote:You still haven't read https://www.postgresql.org/download/linux/redhat/ and https://www.postgresql.org/support/versioning/.All your questions will be answered if you read them.On Wed, Jun 26, 2024 at 2:34 AM Wasim Devale <wasimd60@xxxxxxxxx> 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.
Thanks,
WasimOn Wed, 26 Jun, 2024, 11:58 am Ron Johnson, <ronljohnsonjr@xxxxxxxxx> wrote: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@xxxxxxxxx> 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 ?
Thanks,
WasimOn Wed, 26 Jun, 2024, 1:23 am Ron Johnson, <ronljohnsonjr@xxxxxxxxx> wrote:On Tue, Jun 25, 2024 at 3:21 PM Wasim Devale <wasimd60@xxxxxxxxx> wrote:Hi AllAnybody has live experience on installation of postgresql 12.19 on RHEL 9 server?That too running pg for a long term without any issues.It'll be EOL in five months: https://www.postgresql.org/support/versioning/
