Tatsuo Ishii <[EMAIL PROTECTED]> writes: > Strange enough, there's no other backend (of course except stats > collectors) here. I make sure this with ps and pg_stat_activity view.
If you have no better way of determining what's going on, it might help to recompile with LOCK_DEBUG defined, then enable trace_lwlocks in postgresql.conf (better turn on debug_print_query, log_timestamp, and log_pid too). This will generate rather voluminous log output, perhaps enough to provide a clue. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]