Re: dropping a large table is taking a very long time (about 2 hours so far)

Поиск
Список
Период
Сортировка
От Steve Crawford
Тема Re: dropping a large table is taking a very long time (about 2 hours so far)
Дата
Msg-id 5060CD6B.4010404@pinpointresearch.com
обсуждение исходный текст
Ответ на dropping a large table is taking a very long time (about 2 hours so far)  (Evan Walter <ewalter@decisionanalyst.com>)
Список pgsql-admin
Дерево обсуждения 
On 09/24/2012 02:10 PM, Evan Walter wrote:
> There were probaby about 5 million records in the table.  I do not
> believe there were any foreign keys to the table The drop table has
> been going for over 2 hours.  Is that normal?
I'd check for locks from other transactions preventing the drop. One
possibility is a running backup.

Cheers,
Steve

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

Предыдущее
От: Evan Walter
Дата:
Сообщение: dropping a large table is taking a very long time (about 2 hours so far)
Следующее
От: henk de wit
Дата:
Сообщение: Spurious failure to obtain row lock possible in PG 9.1?