db adapter: update to psycopg3

[iulusoy]

If there is no specific reason to use psycopg2 and not psycopg3 for the db adapter, this could be updated.

• differences
• performance benchmark