Home > mailing lists

Thread: delete performance is extremely slow

delete performance is extremely slow

From

"surabhi.ahuja"

Date:

08 November 2006, 05:50:03

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

the total number of rows in table a is around 10

table b is around 20, similarly table c has around 20.

table d however has arounf 10,00000

delete from a is taking so long . So i just stopped it.

what is going wrong

thanks,

regards

Surabhi

Re: delete performance is extremely slow

From

Alan Hodgson

Date:

08 November 2006, 06:11:32

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