Re: Poor performance for delete query - Mailing list pgsql-performance

From Tom Lane
Subject Re: Poor performance for delete query
Date
Msg-id 6664.1398436604@sss.pgh.pa.us
Whole thread Raw
In response to Re: Poor performance for delete query  (Jonatan Evald Buus <jonatan.buus@cellpointmobile.com>)
List pgsql-performance
Jonatan Evald Buus <jonatan.buus@cellpointmobile.com> writes:
> On 24 April 2014 23:25, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> Jonatan Evald Buus <jonatan.buus@cellpointmobile.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


pgsql-performance by date:

Previous
From: Дмитрий Шалашов
Date:
Subject: Re: Server vacuuming the same table again and again
Next
From: Michael Paquier
Date:
Subject: Re: pl/pgsql performance