pgsql/src/backend/commands trigger.c - Mailing list pgsql-committers

From Tom Lane
Subject pgsql/src/backend/commands trigger.c
Date
Msg-id 200103122302.f2CN20O28261@hub.org
Whole thread Raw
List pgsql-committers
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.


pgsql-committers by date:

Previous
From: Tom Lane
Date:
Subject: Re: pgsql/src Makefile.shlib
Next
From: Tom Lane
Date:
Subject: pgsql/contrib/pg_controldata Makefile README.p ...