Not sure how big of a lift it would be, but it sounds like there is better COPY support as well as better support for connection pooling with psycopg3 over psycopg2, which may be useful for triage. Might need to check if upgrading would require any changes to ohio as well.
Not sure how big of a lift it would be, but it sounds like there is better COPY support as well as better support for connection pooling with
psycopg3
overpsycopg2
, which may be useful for triage. Might need to check if upgrading would require any changes to ohio as well.A few quick links to start from:
project homepage
postgresql post
review of pooling