Airflow use SequentialExecutor by default. However SequentialExecutor does not support postgresql, so it could be better to mentioned this when user decide to use postgresql instead of sqlite.
https://airflow.apache.org/docs/apache-airflow/stable/executor/sequential.html