Python and Advanced PostgreSQL with psycopg2 - Connections vs transactions in psycopg2