"Thomas Chille" <thomas@xxxxxxxxx> writes: > Ah ok, 9293 is a triggerd process and tries to "ALTER TABLE ... > DISABLE TRIGGER (other trigger)" and so implicitly tries to acquire an > AccessExclusiveLock and runs in a deadlock? Well, you're certainly risking deadlock with that; and even if no actual deadlock happens, waiting for the exclusive lock needed to do the ALTER can cause the kind of lock queueing you had here. I'd suggest trying to think of a way to solve your problem that doesn't need trigger enabling/disabling. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly