import psycopg

with psycopg.connect("dbname=postgres user=postgres port=5434 host=localhost") as conn:

    conn.execute("SELECT * FROM foo ORDER BY a OFFSET %s LIMIT %s", [100000,2])
    conn.execute("SELECT 1")

    conn.close()