Thread: pgsql/src/backend/commands trigger.c

pgsql/src/backend/commands trigger.c

From
Tom Lane
Date:
CVSROOT:    /home/projects/pgsql/cvsroot
Module name:    pgsql
Changes by:    tgl@hub.org    01/03/12 18:02:00

Modified files:
    src/backend/commands: trigger.c

Log message:
    Avoid O(N^2) behavior in deferredTriggerAddEvent() for large numbers of
    tuples inserted/deleted/updated in a single transaction.  On my machine,
    this reduced the time to delete 80000 tuples in a foreign-key-referencing
    table from ~15min to ~8sec.