On Thu, 07 Jul 2005 13:16:30 +0200, Bendik Rognlien Johansen <[EMAIL PROTECTED]> wrote:

I was wondering if there is any way to speed up deletes on this table (see details below)? I am running few of these deletes (could become many more) inside a transaction and each one takes allmost a second to complete.
Is it because of the foreign key constraint, or is it something else?


Check your references : on delete, pg needs to find which rows to cascade-delete, or set null, or restrict, in the tables which reference this one. Also if this table references another I think it will lookup it too. Do you have indexes for all this ?

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?


Reply via email to