babelfish-for-postgresql / babelfish_extensions / 20480720435

76%

BABEL_5_X_DEV: 77%

Build Type

push

github

Committed by web-flow

Commit Message

Fix excessive locking in functions accessing Babelfish catalogs (#4348)

Currently, some functions that access Babelfish catalog tables acquire locks of
higher level than necessary even though they only perform read-only operations.
This excessive locking can reduce concurrency and cause unnecessary contention
on frequently accessed catalogs. This fix modifies the functions to use
appropriate lock level where excessive locking occurs on Babelfish catalogs.
It also resolves lock mismatch issue where table_open and table_close calls use
different lock levels.

Cherry picked from #4320

Issues Resolved
BABEL-6205

Authored-by: Rucha Kulkarni ruchask@amazon.com

Run Details

23 of 32 new or added lines in 7 files covered. (71.88%)

2 existing lines in 1 file now uncovered.

50425 of 66195 relevant lines covered (76.18%)

396553.9 hits per line