Re: on delete cascade slowing down delete

From: Alban Hertroys <dalroi(at)solfertje(dot)student(dot)utwente(dot)nl>
To: Ivan Sergio Borgonovo <mail(at)webthatworks(dot)it>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: on delete cascade slowing down delete
Date: 2008-08-22 06:48:30
Message-ID: E92FDCEB-3935-4887-824D-C95EDF9E1A68@solfertje.student.utwente.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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!

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message andy petrella 2008-08-22 07:08:52 hi 5 mess...
Previous Message Decibel! 2008-08-22 05:34:16 Re: Single character bitfields