Re: delete performance is extremely slow

On Tuesday 07 November 2006 22:59, "surabhi.ahuja"
<surabhi.ahuja@iiitb.ac.in> wrote:
> I am using postgresql 8.0.0
>
> i have 4 tables a, b, c, d.
> with foreign key constraints.
> between table b and a
> between c and b
> and between d and c
>
> I am doing delete from a
>
> delete from a is taking so long . So i just stopped it.
> what is going wrong

You're most likely missing an index on one of the foreign key fields in one
of the tables that the delete is cascading to.

--
"A democracy is a sheep and two wolves deciding on what to have for
lunch.  Freedom is a well armed sheep contesting the results of the
decision." -- Benjamin Franklin