Curious if anyone has gone through the ODC-required Postgres upgrade from 13 to 16.6 yet.
If so, how did it go? I’m especially interested in any issues you ran into during the upgrade or testing afterwards.
I’m planning to upgrade our Development environment on April 25th.
Any tips, gotchas, or general suggestions to help make it as smooth as possible would be much appreciated 🙂
I have completed the upgrade in my development environment, and did come across an unexpected issue.
Issue: Report queries timing out
Fix: Created new indexes on tables
It was interesting to see that some SQL queries that were performant with PG13 ran into issues with PG16. The indexes on these tables should have originally been created, but the upgrade uncovered them.
I defintely recommend fully testing your application(s) during this upgrade :)
@Tim Lewis : Thanks for sharing - that is a really useful heads up. Were the indexes you added mostly on columns used in joins/filters for the report queries, or did you notice any other common pattern ?
Mostly columns used in the WHERE clause. This was only affecting tables with a large number of records. 100k+
That makes sense. Thanks for clarifying.