Postgres Pro
Downloads
Home   >   mailing lists

Slow delete - Mailing list pgsql-novice

From Colin Gillespie
Subject Slow delete
Date
Msg-id 20DA376D0C991745A4D5249F7BCD7A250D384D@largo.campus.ncl.ac.uk
Whole thread Raw
Responses Re: Slow delete  (Sean Davis <sdavis2@mail.nih.gov>)
Re: Slow delete  (Andrew Hammond <ahammond@ca.afilias.info>)
List pgsql-novice
Tree view 
Dear All,

I have four tables linked together with FK. An example is, deleting an id in one table, deletes 1,000,000 rows in all
theothers. However, this operation takes 2-3mins (currently this more or less empties the database.) Is this slow?  

I have checked that the FK have been indexed and that they have been declared intergers. A full vacuum has also been
performed.

Does anyone have any suggestions on how to speed this up?

Thanks

Colin

pgsql-novice by date:

Previous
From: "Colin Gillespie"
Date:
Subject: Re: triggers, transactions and locks
Next
From: Sean Davis
Date:
Subject: Re: Slow delete