Explore migrating to psycopg3

[shaycrk]

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.

A few quick links to start from:

project homepage

postgresql post

review of pooling