GitHub user tgrandje closed a discussion: Deploy airflow with postgresql and pooling
Airflow's documentation states that setting a postgresql database in production may require PgBouncer because of an important number of connections: * see here in [Setting up a PostgreSQL Database](https://airflow.apache.org/docs/apache-airflow/stable/howto/set-up-database.html#setting-up-a-postgresql-database) * see also here in [production guide](https://airflow.apache.org/docs/helm-chart/stable/production-guide.html#pgbouncer) for helm-chart. On the other hand, the configuration documentation states that airflow uses (by default config) a SqlAlchemy pool : * [sql-alchemy-pool-enabled](https://airflow.apache.org/docs/apache-airflow/stable/configurations-ref.html#sql-alchemy-pool-enabled) : default is True * [sql_alchemy_pool_size](https://airflow.apache.org/docs/apache-airflow/stable/configurations-ref.html#sql-alchemy-pool-size) : default is 5 That seems conflicting to me. Is any of this outdated? (I'll open an issue on this if confirmed.) GitHub link: https://github.com/apache/airflow/discussions/48231 ---- This is an automatically sent email for [email protected]. To unsubscribe, please send an email to: [email protected]
