https://outerbounds.com/ logo
Join Slack
Powered by
We're having some RDS performance issues and are r...
# ask-metaflow
p
We're having some RDS performance issues and are running on postgres db_engine_version 12.17. I note that the terraform-aws-metaflow module specifies db_engine_version 11 by default. To jump to the r7g instances (from r6g) requires postgres engine version 13 or better. Are there any known issues with higher postgres db engine versions? I don't see anything in the github issues, but wanted to check here out of an abundance of caution.
In a similar vein, we've just upgraded the backend from 2.4.3 to 2.4.4 to take advantage of the separate db reader pool and are seeing a ton of async timeout errors around 
ERROR:AsyncPostgresDB:ui:heartbeat:Exception occurred
with asyncio.exceptions.CancelledError which makes me wonder if it's a db load issue or a problem with the separate db reader pool. We didn't have this error in our sandbox environment so I'd though it load related rather than a code issue, but now I'm not sure.
In fact, this was a missing index on our side due to our messing up the migration scripts. Still trying the postgres13 engine
b
there shouldn't be any issues with going to v13. The main feature that the UI leverages from Postgres specifically is the table triggers / notify mechanism for realtime updates, and that is still available. There was a discussion about DB upgrades a few months ago as well https://outerbounds-community.slack.com/archives/C02116BBNTU/p1704986794008909
thankyou 1
p
Very helpful. We went from postgres 12 to 13 in our sandbox env with no problems, so I'll eventually roll that out company wide before trying the 13->14 and beyond
6 Views
Open in Slack
PreviousNext
Powered by