Compare disconnect/reconnect and pooled times

disconnect.py

#!/usr/bin/env python
#
# Disconnect/reconnect each query
#
# Takes 0.45s to run here
#
import time
import psycopg2

start_t = time.time()

for x in range(1, 100):
        conn = psycopg2.connect('dbname=test')
        curs = conn.cursor()
        curs.execute("SELECT 1;")
        curs.fetchall()
        curs.close()
        conn.close()

end_t = time.time()

print "Elapsed: ", end_t - start_t

pooled.py

#!/usr/bin/env python
#
# Re-use connection
#
# Takes 0.01s to run here
import time
import psycopg2

start_t = time.time()
conn = psycopg2.connect('dbname=test')

for x in range(1, 100):
	curs = conn.cursor()
	curs.execute("SELECT 1;")
	curs.fetchall()
	curs.close()

conn.close()
end_t = time.time()

print "Elapsed: ", end_t - start_t