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

Reply via email to