Content-Length: 235631 | pFad | http://github.com/postgrespro/postgres/commit/45ba424f332a7eaa685a4e23f142a43114c65811

B1 Cache the results of ri_FetchConstraintInfo in a backend-local cache. · postgrespro/postgres@45ba424 · GitHub
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)








ApplySandwichStrip

pFad - (p)hone/(F)rame/(a)nonymizer/(d)eclutterfier!      Saves Data!


--- a PPN by Garber Painting Akron. With Image Size Reduction included!

Fetched URL: http://github.com/postgrespro/postgres/commit/45ba424f332a7eaa685a4e23f142a43114c65811

Alternative Proxies:

Alternative Proxy

pFad Proxy

pFad v3 Proxy

pFad v4 Proxy