on delete cascade slowing down delete

Поиск
Список
Период
Сортировка
От Ivan Sergio Borgonovo
Тема on delete cascade slowing down delete
Дата
Msg-id 20080821190632.6ef138f2@dawn.webthatworks.it
обсуждение исходный текст
Ответы Re: on delete cascade slowing down delete  (Alan Hodgson <ahodgson@simkin.ca>)
Re: on delete cascade slowing down delete  (David Fetter <david@fetter.org>)
Список pgsql-general
I've a large table with a pk and several smaller tables with fk
referencing to it.

deleting from the first table is very slow.

Not all the related fk have indexes but they are VERY small (0 to
100 records) while the main table contain 600-800K records.

the
explain delete p;
doesn't give any clue.

Any hint to track down the problem?

thanks

--
Ivan Sergio Borgonovo
http://www.webthatworks.it


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

Предыдущее
От: Robert Gobeille
Дата:
Сообщение: Re: plpgsql - sorting result set
Следующее
От: Mark Roberts
Дата:
Сообщение: Re: What's size of your PostgreSQL Database?