Jonatan Evald Buus <jonatan.buus@xxxxxxxxxxxxxxxxxxx> writes: > On 24 April 2014 23:25, Tom Lane <tgl@xxxxxxxxxxxxx> wrote: >> Jonatan Evald Buus <jonatan.buus@xxxxxxxxxxxxxxxxxxx> 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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance