Re: [PERFORM] How to speed up delete

2005-07-07 Thread Bendik Rognlien Johansen
Thanks! That took care of it. On Jul 7, 2005, at 4:02 PM, Tom Lane wrote: Bendik Rognlien Johansen <[EMAIL PROTECTED]> 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 const

Re: [PERFORM] How to speed up delete

2005-07-07 Thread Tom Lane
Bendik Rognlien Johansen <[EMAIL PROTECTED]> 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 sup

Re: [PERFORM] How to speed up delete

2005-07-07 Thread PFC
On Thu, 07 Jul 2005 13:16:30 +0200, Bendik Rognlien Johansen <[EMAIL PROTECTED]> 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 allmo