Re: How to speed up delete - Mailing list pgsql-performance

From PFC
Subject Re: How to speed up delete
Date
Msg-id op.stjniqzbth1vuj@localhost
Whole thread Raw
In response to How to speed up delete  (Bendik Rognlien Johansen <bendik.johansen@gmail.com>)
List pgsql-performance
On Thu, 07 Jul 2005 13:16:30 +0200, Bendik Rognlien Johansen
<bendik.johansen@gmail.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 ?

pgsql-performance by date:

Previous
From: Jean-Max Reymond
Date:
Subject: Surprizing performances for Postgres on Centrino
Next
From: PFC
Date:
Subject: Re: