vatsrahul1001 opened a new issue, #63550: URL: https://github.com/apache/airflow/issues/63550
### Apache Airflow version 3.1.8 ### If "Other Airflow 3 version" selected, which one? _No response_ ### What happened? Migration 0106_3_2_0_add_partition_key_to_backfill_dag_run upgrade is slow on deployments with large dag_run tables. With 10M dag_run rows, the migration took ~6 minutes. ### What you think should happen instead? _No response_ ### How to reproduce 1. Start Airflow on 3.1.8 with PostgreSQL backend 2. Accumulate dag_run rows (100K+ to see noticeable impact, 1M+ for significant delays) 3. Upgrade to 3.2.0 (airflow db migrate) 4. Observe migration 0106 duration scales linearly with dag_run row count ### Operating System MAc ### Versions of Apache Airflow Providers _No response_ ### Deployment Official Apache Airflow Helm Chart ### Deployment details _No response_ ### Anything else? _No response_ ### Are you willing to submit PR? - [ ] Yes I am willing to submit a PR! ### Code of Conduct - [x] I agree to follow this project's [Code of Conduct](https://github.com/apache/airflow/blob/main/CODE_OF_CONDUCT.md) -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
