Litao Wu <[EMAIL PROTECTED]> writes: > Since there are multiple databases and > there are 170 postgres processes this morning, > 60 of them are access the problem database, > and 57 of 60 are non-idle.
> We only need to gdb those 57 processes, or > we need gdb 60 or 170? Potentially the deadlock could be anywhere :-(. You should definitely not assume it must be one of the processes connected to the problem database, because the buffer pool is cluster-wide. Might be worth setting up a shell script to help. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org