Re: FK triggers misused?

From: Tom Lane
Subject: Re: FK triggers misused?
Date: ,
Msg-id: 26399.1176614941@sss.pgh.pa.us
(view: Whole thread, Raw)
In response to: FK triggers misused?  (cluster)
List: pgsql-performance

Tree view

FK triggers misused?  (cluster, )
 Re: FK triggers misused?  (Tom Lane, )
 Re: FK triggers misused?  (Andrew - Supernews, )
  Re: FK triggers misused?  (Tom Lane, )
 Re: FK triggers misused?  (Andrew - Supernews, )
  Re: FK triggers misused?  (cluster, )
   Re: FK triggers misused?  (Tom Lane, )
   Re: FK triggers misused?  (Tom Lane, )
    Re: FK triggers misused?  (cluster, )
 Re: FK triggers misused?  (cluster, )
  Re: FK triggers misused?  (Stephan Szabo, )

cluster <> 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:

From: Andrew - Supernews
Date:
Subject: Re: FK triggers misused?
From: Tom Lane
Date:
Subject: Re: FK triggers misused?