It seems like the default SQLite database is locking up all the time but not affecting anything… is there any reason to change the SQLite database to PostgreSQL?

How are you planning to deploy the Prefect instance in production?