| From: | Andrew - Supernews <andrew+nonews(at)supernews(dot)com> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: FK triggers misused? |
| Date: | 2007-04-15 05:42:49 |
| Message-ID: | slrnf23eqp.10cj.andrew+nonews@atlantis.supernews.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On 2007-04-15, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> 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?
Looking at current CVS code the RI check seems to be skipped on update of
the _referred to_ table if the old and new values match, but not on update
of the _referring_ table.
--
Andrew, Supernews
http://www.supernews.com - individual and corporate NNTP services
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Steve | 2007-04-15 08:13:53 | Re: [HACKERS] choose_bitmap_and again (was Re: [PERFORM] Strangely Variable Query Performance) |
| Previous Message | Tom Lane | 2007-04-15 05:29:01 | Re: FK triggers misused? |