#!/usr/bin/python

import sys, time
import psycopg

count = 500000

db = psycopg.connect("user=postgres dbname=test")
db.autocommit(True)

dbc = db.cursor()
dbc.execute("CREATE TABLE test (data TEXT);")

sys.stdout.flush()
start_t = time.time()
for i in range(count):
        dbc.execute("INSERT INTO test VALUES('insert no. %d');" % i)

diff_t = time.time() - start_t
print "%d inserts in %0.3f seconds, %f inserts/sec" % (count, diff_t, count / diff_t)

dbc.execute("DROP TABLE test;")