Re: deadlock with vacuum full on 7.4.5

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: deadlock with vacuum full on 7.4.5
Дата
Msg-id 8220.1097622346@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: deadlock with vacuum full on 7.4.5  (Joseph Shraibman <jks@selectacast.net>)
Ответы Re: deadlock with vacuum full on 7.4.5
Список pgsql-general
Joseph Shraibman <jks@selectacast.net> 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

В списке pgsql-general по дате отправления:

Предыдущее
От: Joseph Shraibman
Дата:
Сообщение: Re: deadlock with vacuum full on 7.4.5
Следующее
От: Joseph Shraibman
Дата:
Сообщение: Re: deadlock with vacuum full on 7.4.5