Re: FK triggers misused?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: cluster <skrald(at)amossen(dot)dk>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: FK triggers misused?
Date: 2007-04-15 05:29:01
Message-ID: 26399.1176614941@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

cluster <skrald(at)amossen(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Andrew - Supernews 2007-04-15 05:42:49 Re: FK triggers misused?
Previous Message Tom Lane 2007-04-15 05:11:02 Re: [HACKERS] choose_bitmap_and again (was Re: [PERFORM] Strangely Variable Query Performance)