lock table problem
folk
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.
where is the way to investigate lock's table tree ?
any clue?
best regards
MDC
__________________________________________________
Pregunt�. Respond�. Descubr�.
Todo lo que quer�as saber, y lo que ni imaginabas,
est� en Yahoo! Respuestas (Beta).
�Probalo ya!
http://www.yahoo.com.ar/respuestas
marcelo Cortez <jmdc_marcelo@yahoo.com.ar> 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