Slow delete

Поиск
Список
Период
Сортировка
От Colin Gillespie
Тема Slow delete
Дата
Msg-id 20DA376D0C991745A4D5249F7BCD7A250D384D@largo.campus.ncl.ac.uk
обсуждение исходный текст
Ответы Re: Slow delete  (Sean Davis <sdavis2@mail.nih.gov>)
Re: Slow delete  (Andrew Hammond <ahammond@ca.afilias.info>)
Список pgsql-novice
Dear All,

I have four tables linked together with FK. An example is, deleting an id in one table, deletes 1,000,000 rows in all
theothers. However, this operation takes 2-3mins (currently this more or less empties the database.) Is this slow?  

I have checked that the FK have been indexed and that they have been declared intergers. A full vacuum has also been
performed.

Does anyone have any suggestions on how to speed this up?

Thanks

Colin

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

Предыдущее
От: "Colin Gillespie"
Дата:
Сообщение: Re: triggers, transactions and locks
Следующее
От: Sean Davis
Дата:
Сообщение: Re: Slow delete