I'm using psycopg2, python2.7.3 threading along with pgsql 9.1.5. I noticed that if I have my python process query against the database kind of frequently, say more than 1 query per second, it's almost 100% sure to hit some problem, but first some backgroud:
1. There are three threads, each with many SELECT/UPDATE, a little bit INSERT, only one explicit 'LOCK TABLE' 2. One of threads queries the db every second (easier to reproduce this way) 3. The other two do their queries like every 10~30 seconds 4. It doesn't matter whether the threads share one connection or with separate connection,