Inefficiency in FK triggers - Mailing list pgsql-hackers

From Tom Lane
Subject Inefficiency in FK triggers
Date
Msg-id 13053.1177360127@sss.pgh.pa.us
Whole thread Raw
List pgsql-hackers
While poking at Michel Dorochevsky's issue, I noticed that if a DELETE
is done in a table that is referenced by many different foreign keys,
we repeat the ri_Check_Pk_Match test over again for each FK.  Seems like
it would be nice to avoid this duplicated work.  But right now I don't
see any easy way to refactor the RI triggers for it --- the triggers are
independent.  Something to think about in future, maybe.
        regards, tom lane


pgsql-hackers by date:

Previous
From: August Zajonc
Date:
Subject: Re: Wild idea: 9.0?
Next
From: Neil Conway
Date:
Subject: Re: Improving deadlock error messages