- Notifications
You must be signed in to change notification settings - Fork5
Commit45ba424
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 theruntime 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 abackend-local cache of the results. This is really a pretty small patch,but converting the trigger functions to work with pointers rather thanlocal struct variables requires a lot of mechanical changes.1 parentcfa0f42 commit45ba424
1 file changed
+319
-229
lines changed0 commit comments
Comments
(0)