Re: Extremely Slow Cascade Delete Operation

Поиск
Список
Период
Сортировка
От Grzegorz Jaśkiewicz
Тема Re: Extremely Slow Cascade Delete Operation
Дата
Msg-id 2f4958ff1001130035g442cf78cj43b9ef2772b122d4@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Extremely Slow Cascade Delete Operation  (Yan Cheng Cheok <yccheok@yahoo.com>)
Ответы Re: Extremely Slow Cascade Delete Operation  (Yan Cheng Cheok <yccheok@yahoo.com>)
Re: Extremely Slow Cascade Delete Operation  (Yan Cheng Cheok <yccheok@yahoo.com>)
Список pgsql-general
It doesn't look like it is locked, so it is carrying the delete out.
However that doesn't mean, that there isn't any other locking
occurring, or simply your disks are rather busy.

Also, maybe the DB is rather big, what are the table sizes ?
If you are using 8.4+, than do \dt+ to get an idea, otherwise SELECT
pg_size_pretty(pg_total_relation_size('table_name')); for each table.

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

Предыдущее
От: Yan Cheng Cheok
Дата:
Сообщение: Re: Extremely Slow Cascade Delete Operation
Следующее
От: Yan Cheng Cheok
Дата:
Сообщение: Re: Extremely Slow Cascade Delete Operation