Re: LONG delete with LOTS of FK's

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: LONG delete with LOTS of FK's
Дата
Msg-id 6281.1368134523@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: LONG delete with LOTS of FK's  (Larry Rosenman <ler@lerctr.org>)
Ответы Re: LONG delete with LOTS of FK's  (Larry Rosenman <ler@lerctr.org>)
Список pgsql-general
Дерево обсуждения 
Larry Rosenman <ler@lerctr.org> writes:
>> Ideas on how to debug?

Perhaps it's blocked on a lock?  Did you look into pg_locks?
Did you note whether the process was consuming CPU time and/or doing IO?

            regards, tom lane

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

Предыдущее
От: Shaun Thomas
Дата:
Сообщение: Re: LONG delete with LOTS of FK's
Следующее
От: Larry Rosenman
Дата:
Сообщение: Re: LONG delete with LOTS of FK's