Hi everyone is there a recommended way to set up a Postgres

Question

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

Jack Sundberg · Answer

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>

Jack Sundberg · Answer

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

Anna Geller · Answer

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

Jack Sundberg · Answer

Sure I ll open an issue after lunch