delete performance is extremely slow
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
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 cI 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