Bring your towel and join one of the fastest growing data communities. Welcome to our second-generation open source orchestration platform, a completely rethought approach to dataflow automation.

Prefect Community

Hi everyone, is there a recommended way to set up a Postgres connection pool for the Orion database? I typically use pgbouncer to build a transactional pool, but when I do this with prefect, I end up an error matching <https://github.com/sqlalchemy/sqlalchemy/issues/6467|a known bug> in sqlalchemy.

If the sqlalchemy bug is fixed, I may open a PR to allow passing extra `connection_args` to `create_async_engine` (such as `statement_cache_size`)

The PR would update the code <https://github.com/PrefectHQ/prefect/blob/orion/src/prefect/orion/database/configurations.py#L194-L215|here>

The PR would modify the code <https://github.com/PrefectHQ/prefect/blob/orion/src/prefect/orion/database/configurations.py#L194-L215|here> using some new environment variable

Do you want to open an issue for it in the prefect repo? Not sure how much we can do about it in a Slack thread now