That is what I wanted to know, how to get the evidence for next time.
Tom Lane wrote:
Joseph Shraibman <[EMAIL PROTECTED]> writes:
Why then when I did a kill -INT on the vacuuming backends did everything unfreeze?
You could have had other stuff backed up behind the VACUUM FULL lock requests.
It's not impossible that you had a deadlock *outside* the database, that is some wait loop that is partially within and partially outside the DB. But if you want me to believe there's a bug in our deadlock detector, you're going to have to offer some actual evidence...
regards, tom lane
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html