Re: on delete cascade slowing down delete - Mailing list pgsql-general

From Alban Hertroys
Subject Re: on delete cascade slowing down delete
Date
Msg-id E92FDCEB-3935-4887-824D-C95EDF9E1A68@solfertje.student.utwente.nl
Whole thread Raw
In response to Re: on delete cascade slowing down delete  (Ivan Sergio Borgonovo <mail@webthatworks.it>)
Responses Re: on delete cascade slowing down delete  (Ivan Sergio Borgonovo <mail@webthatworks.it>)
List 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 by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Pg dump Error
Next
From: "andy petrella"
Date:
Subject: hi 5 mess...