Re: 7.3.3 drop table takes very long time

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: 7.3.3 drop table takes very long time
Дата
Msg-id 11970.1073582209@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: 7.3.3 drop table takes very long time  (Mike Mascari <mascarm@mascari.com>)
Список pgsql-general
Mike Mascari <mascarm@mascari.com> writes:
> Is there any possibility that he's got an open transacation sitting out
> there for days holding a lock on that table?

Good thought ... but if that was the issue then the DROP would just be
sleeping waiting for the lock, and Eric did say it was consuming CPU ...

            regards, tom lane

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

Предыдущее
От: Mike Mascari
Дата:
Сообщение: Re: 7.3.3 drop table takes very long time
Следующее
От: Travel Jadoo
Дата:
Сообщение: Re: order by is ambiguous