Re: [GENERAL] How to inspect blocked queries

2001-03-22 Thread Tom Lane
"Randall F. Kern" <[EMAIL PROTECTED]> writes: > I have an web application that sometimes hangs. When I run ps I see a > postgresql thread that says "INSERT waiting" (I don't have the exact > text in front of me, but it's similar to that). When this happens my > only recourse is to restart my web

[GENERAL] How to inspect blocked queries

2001-03-21 Thread Randall F. Kern
I have an web application that sometimes hangs. When I run ps I see a postgresql thread that says "INSERT waiting" (I don't have the exact text in front of me, but it's similar to that). When this happens my only recourse is to restart my webserver or database. Now most likely I have another tr