On Tuesday 07 November 2006 22:59, "surabhi.ahuja" <surabhi.ahuja@xxxxxxxxxxx> 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
