delete performance is extremely slow - Mailing list pgsql-general

From surabhi.ahuja
Subject delete performance is extremely slow
Date
Msg-id 8626C1B7EB748940BCDD7596134632BE3986AA@jal.iiitb.ac.in
Whole thread Raw
Responses Re: delete performance is extremely slow  (Alan Hodgson <ahodgson@simkin.ca>)
List pgsql-general
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
 
 
 
 

pgsql-general by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: [ADMIN] Is there anyway to...
Next
From: Alan Hodgson
Date:
Subject: Re: delete performance is extremely slow