[GENERAL] lock table problem

2006-08-24 Thread marcelo Cortez
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

Re: [GENERAL] lock table problem

2006-08-24 Thread Tom Lane
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