https://prefect.io logo
Title
j

Jack Sundberg

07/17/2022, 1:59 PM
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 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 here
The PR would modify the code here using some new environment variable
a

Anna Geller

07/17/2022, 4:02 PM
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
j

Jack Sundberg

07/17/2022, 4:17 PM
Sure, I'll open an issue after lunch!
:thank-you: 1