Re: on delete cascade slowing down delete

Поиск
Список
Период
Сортировка
От Alban Hertroys
Тема Re: on delete cascade slowing down delete
Дата
Msg-id E92FDCEB-3935-4887-824D-C95EDF9E1A68@solfertje.student.utwente.nl
обсуждение исходный текст
Ответ на Re: on delete cascade slowing down delete  (Ivan Sergio Borgonovo <mail@webthatworks.it>)
Ответы Re: on delete cascade slowing down delete  (Ivan Sergio Borgonovo <mail@webthatworks.it>)
Список pgsql-general
> Is it going to make things faster if I:
>
> delete from s;
> reindex table s;

Why do you think this step would help you any? There's no index on p
to begin with. You'd just be reindexing the auto-generated unique
index on s (due to it being a PK).

> delete from p;

And no, this would most likely be slower.

Alban Hertroys

--
If you can't see the forest for the trees,
cut the trees and you'll see there is no forest.


!DSPAM:737,48ae6140243481364815068!



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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: Pg dump Error
Следующее
От: "andy petrella"
Дата:
Сообщение: hi 5 mess...