]> granicus.if.org Git - postgresql/commit
projects / postgresql / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 74c732c) | patch
Avoid O(N^2) behavior in deferredTriggerAddEvent() for large numbers of
authorTom Lane <tgl@sss.pgh.pa.us>
Mon, 12 Mar 2001 23:02:00 +0000 (23:02 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Mon, 12 Mar 2001 23:02:00 +0000 (23:02 +0000)
commitb246510ccc8db96bf7a536a305cccf65aab21ce8
tree1b08d59b3fe5e95ceb0604f0ac8e49fd30c995dctree | snapshot
parent74c732cb87318b73d172320869aedd64fbdd4388commit | diff
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.
src/backend/commands/trigger.c diff | blob | history
Unnamed repository; edit this file 'description' to name the repository.