> Maybe something else had a nontrivial lock on the table, and those commands > were waiting on lock. If you "SET deadlock_timeout='1'; SET > log_lock_waits=on;", then you could see that.
Just checking - I think you mean lock_timeout? (although setting deadlock_timeout is also not a bad idea just in case).