pgsql/src/backend/commands trigger.c

From: Tom Lane <tgl(at)hub(dot)org>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql/src/backend/commands trigger.c
Date: 2001-03-12 23:02:00
Message-ID: 200103122302.f2CN20O28261@hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

CVSROOT: /home/projects/pgsql/cvsroot
Module name: pgsql
Changes by: tgl(at)hub(dot)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.

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2001-03-13 01:17:07 pgsql/ oc/src/sgml/ref/checkpoint.sgml oc/src/ ...
Previous Message Tom Lane 2001-03-12 17:39:22 Re: pgsql/src Makefile.shlib