Re: Poor performance for delete query

Jonatan Evald Buus <jonatan(dot)buus(at)cellpointmobile(dot)com> writes:
> On 24 April 2014 23:25, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>> Jonatan Evald Buus <jonatan(dot)buus(at)cellpointmobile(dot)com> writes:
>>> Why is "order2transaction_fk" being triggered twice? Is that because
>>> there're two affected rows?

>> No, I'd have expected a delete of multiple rows to show as calls=N,
>> not N separate entries.

> This doesn't explain the extra trigger of "order2transaction_fk".
> Any guidelines as to how we may investigate this further would be greatly
> appreciated.

If you could show us your exact database schema, it might become
clearer what's happening. I'm wondering about duplicate constraint names
for instance ...

regards, tom lane