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

Поиск
Список
Период
Сортировка
От Evan Walter
Тема dropping a large table is taking a very long time (about 2 hours so far)
Дата
Msg-id CAOHVLOFBYojG-6tSMB3PM2a2CSO3B434svFGDudLdg5rVCMVLg@mail.gmail.com
обсуждение исходный текст
Ответы Re: dropping a large table is taking a very long time (about 2 hours so far)
Re: dropping a large table is taking a very long time (about 2 hours so far)
Список pgsql-admin
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?

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

Предыдущее
От: Marcello Perathoner
Дата:
Сообщение: Re: CPU causes 100% load in user space when ntp client runs and postgresql is under heavy load
Следующее
От: Steve Crawford
Дата:
Сообщение: Re: dropping a large table is taking a very long time (about 2 hours so far)