Brian Cox <brian.cox@xxxxxx> writes: > select locktype,database,relation,virtualxid,virtualtransaction,pid,mode > from pg_locks order by mode; If you hadn't left out the "granted" column we could be more sure, but what it looks like to me is the DROP (pid 13842) is stuck behind the <IDLE> transaction (pid 13833). In particular these two rows of pg_locks look like a possible conflict: > relation | 26472437 | 26472508 | | 15/69749 > | 13842 | AccessExclusiveLock > relation | 26472437 | 26472508 | | 11/131 > | 13833 | AccessShareLock regards, tom lane -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
