I’m facing an issue after migrating my self-hosted...
# ask-community
k
I’m facing an issue after migrating my self-hosted Prefect server from SQLite to PostgreSQL (hosted on AWS RDS). Initially, I was using the default SQLite database, which stored all data locally on the EC2 instance. As the space consumed by events and resource metadata kept growing significantly, I decided to switch to PostgreSQL on RDS. However, after the migration, my flow runs have started taking much longer than before. Previously, an average flow run would complete in around 5 minutes, but now they’re taking 30 minutes or more. Additionally, the next scheduled run (set to trigger every 30 minutes) often starts and enters the RUNNING state before the previous flow has completed. PS: The schedule interval is 30 minutes. Can someone please help me understand what could be causing this slowdown?