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 ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match