Slow delete

From: "Colin Gillespie" <C(dot)Gillespie(at)newcastle(dot)ac(dot)uk>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Slow delete
Date: 2004-12-07 10:54:41
Message-ID: 20DA376D0C991745A4D5249F7BCD7A250D384D@largo.campus.ncl.ac.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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 the others. 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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Sean Davis 2004-12-07 11:09:54 Re: Slow delete
Previous Message Colin Gillespie 2004-12-07 10:11:36 Re: triggers, transactions and locks