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

From Bendik Rognlien Johansen
Subject Re: How to speed up delete
Date
Msg-id F6FA99FB-A195-4BB8-A868-D4B249572EF4@gmail.com
Whole thread Raw
In response to Re: How to speed up delete  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
Thanks!
That took care of it.
On Jul 7, 2005, at 4:02 PM, Tom Lane wrote:

> Bendik Rognlien Johansen <bendik.johansen@gmail.com> writes:
>
>> 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?
>>
>
> You need an index on "original" to support that FK efficiently.  Check
> for references from other tables to this one, too.
>
>             regards, tom lane
>


pgsql-performance by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Surprizing performances for Postgres on Centrino
Next
From: PFC
Date:
Subject: Re: Need suggestion high-level suggestion on how to solve a performance problem