Re: How to speed up delete

On Thu, 07 Jul 2005 13:16:30 +0200, Bendik Rognlien Johansen
<bendik(dot)johansen(at)gmail(dot)com> wrote:

> Hello,
> 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?
>
> Thanks!

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 ?