Re: [GENERAL] delete performance is extremely slow

2006-11-07 Thread Alan Hodgson
On Tuesday 07 November 2006 22:59, "surabhi.ahuja" <[EMAIL PROTECTED]> 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 lo

[GENERAL] delete performance is extremely slow

2006-11-07 Thread surabhi.ahuja
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