marcelo Cortez <[EMAIL PROTECTED]> writes:
> the pg_statistics show too many lock table ( fron my
> app.) and all of them is in waiting state.
> the only way to go out from this situation is restart
> the cluster.
Surely a few query cancels would be sufficient.
> where is the way to investigate lock's table tree ?
The pg_locks view should tell you who's hogging the locks.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
