Recommended backend metastore for Airflow

Hi All,
It seems that Airflow supports mysql, postgresql and mssql as backend store. Any recommendation on using one over other. We are expecting to run 1000(s) of concurrent Dags which would generate heavy load on backend store.
Any pointer on this would be useful.
Thanks,
Raman Gupta