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