Skip to content

Commit 45ba424

Browse files
tglsfdctglsfdc
committed
Cache the results of ri_FetchConstraintInfo in a backend-local cache.
Extracting data from pg_constraint turned out to take as much as 10% of the runtime in a bulk-update case where the foreign key column wasn't changing, because we did it over again for each tuple. Fix that by maintaining a backend-local cache of the results. This is really a pretty small patch, but converting the trigger functions to work with pointers rather than local struct variables requires a lot of mechanical changes.
1 parent cfa0f42 commit 45ba424

File tree

1 file changed

+319
-229
lines changed

1 file changed

+319
-229
lines changed

0 commit comments

Comments
 (0)