On Fri, Sep 14, 2012 at 5:55 PM, David Roid <dataroid(at)gmail(dot)com> wrote:
> 2. When one of the slow ones get called, the whole python process hang, with
> the postgresql process in 'idle in transaction'; note i'm very alert with
> psycopg2's all-in-transaction style, i'm very sure there is a
> commit/rollback to end the trac, the python process just stucks!
Is there any query with "waiting" flag set to true in
pg_stat_activity? That would be an indication of queries stuck against
a lock.
-- Daniele