| From: | Bendik Rognlien Johansen <bendik(dot)johansen(at)gmail(dot)com> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Subject: | Re: How to speed up delete |
| Date: | 2005-07-07 15:03:36 |
| Message-ID: | F6FA99FB-A195-4BB8-A868-D4B249572EF4@gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Thanks!
That took care of it.
On Jul 7, 2005, at 4:02 PM, Tom Lane wrote:
> Bendik Rognlien Johansen <bendik(dot)johansen(at)gmail(dot)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
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | PFC | 2005-07-07 22:21:31 | Re: Need suggestion high-level suggestion on how to solve a performance problem |
| Previous Message | Richard Huxton | 2005-07-07 14:52:33 | Re: Surprizing performances for Postgres on Centrino |