Inserting 100k rows

insert100k.py

    from sqlalchemy import create_engine
    conn = None
    try:
        conn_str = "postgresql+psycopg2://postgres:password@localhost:5432/test"
        engine = create_engine(conn_str, pool_size=3)
        conn = engine.connect()
        for i in range(0, 100000):
            sql = "insert into table1 (a,b,c,d,e) values (%s,%s,%s,%s,%s)"
            conn.execute(sql, (i, 'string for ' + str(i), 'string for ' + str(i), i*0.1, i*0.1))
    finally:
        if conn is not None: conn.close()