Thread: 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