Simple INSERTs into a user_actions table (without use of prepare step)

sql_user_actions_without_prepare.py

# On CentOS you can install psycopg2 thus:
#
#  sudo yum install postgresql-libs
#  sudo yum install python-psycopg2

import psycopg2;
import time

conn = psycopg2.connect("host=localhost dbname=postgres user=postgres port=5433")

conn.set_session(autocommit=True)
cur = conn.cursor()

start_time = time.time()
cur.execute("""DROP TABLE IF EXISTS user_actions""");
now_time = time.time()
print "Dropped (if exists): user_actions table"
print("Time: %s ms ---" % ((now_time - start_time) * 1000))

start_time = time.time()
cur.execute("""
      CREATE TABLE user_actions(
         id integer,
         msg_id integer,
         msg    text,
         PRIMARY KEY(id, msg_id)
      )
  """)
now_time = time.time()
print "Create user_actions table."
print("Time: %s ms ---" % ((now_time - start_time) * 1000))

print("==================")
num_users=200
num_msgs=50
print "Inserting %d rows without use of prepare/bind" % (num_users*num_msgs)
start_time = time.time()
for idx in range(num_users):
  for jdx in range(num_msgs):
     cur.execute("""
        INSERT INTO user_actions(id, msg_id, msg) VALUES (%d, %d, '%s')
      """ % (idx, jdx, "msg--"+str(idx)+"--"+str(jdx)));
now_time = time.time()
print("Inserted %d rows" %  (num_msgs * num_users))
print("Time: %s ms ---" % ((now_time - start_time) * 1000))
print("Avg Time: %s ms ---" % ((now_time - start_time) * 1000 / (num_msgs * num_users)))