babelfish-for-postgresql / babelfish_extensions / 12652337012

75%

BABEL_5_X_DEV: 77%

push

github

Performance Improvement of create login in BBF (#3291) (#3366)

Engine PR : babelfish-for-postgresql/postgresql_modified_for_babelfish#507

In Major version 16 Babelfish introduced a new role bbf_admin_role which is a member of all the roles which created implicitly from TSQL. This increases the Load on any Grant/Revoke operations that happen since in BBF to "select the role through which it gets permission to current user to grant", is inefficient and loops over members of members to find the all members of the role even though the required role is find.
This commit optimizes the selection of role with is_admin_option true for babelfish by escaping the search for any TSQL roles conditionally.

Task: BABEL-5349

Signed-off-by: ANJU BHARTI <abanju@amazon.com>

13 of 16 new or added lines in 2 files covered. (81.25%)

46357 of 62219 relevant lines covered (74.51%)

169013.89 hits per line