Re: FK triggers misused? - Mailing list pgsql-performance

From Tom Lane
Subject Re: FK triggers misused?
Date
Msg-id 26399.1176614941@sss.pgh.pa.us
Whole thread Raw
In response to FK triggers misused?  (cluster <skrald@amossen.dk>)
List pgsql-performance
cluster <skrald@amossen.dk> writes:
> It seems that the FK triggers for the table are evaluated even though
> none of the FK columns are altered.

Hm, they're not supposed to be, at least not in reasonably modern
PG releases (and one that breaks out trigger runtime in EXPLAIN ANALYZE
should be modern enough IIRC).  Exactly which PG release are you
running?  Can you provide a self-contained test case?

            regards, tom lane

pgsql-performance by date:

Previous
From: cluster
Date:
Subject: FK triggers misused?
Next
From: Andrew - Supernews
Date:
Subject: Re: FK triggers misused?