1
75%
BABEL_5_X_DEV: 77%

Ran 07 Jan 2025 01:50PM UTC

Files 115

Run time 5s

Badge

Embed ▾

Committed 07 Jan 2025 01:14PM UTC coverage: 74.506% (+0.005%) from 74.501%

Job # 12652337012.1

Build Type

push

github

Committed by

web-flow

Commit Message

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>

Run Details

46357 of 62219 relevant lines covered (74.51%)

169013.89 hits per line

babelfish-for-postgresql / babelfish_extensions / 12652337012 / 1
75%
BABEL_5_X_DEV: 77%

README BADGES
x

Markdown

Textile

RDoc

HTML

Rst

Source Files on job 12652337012.1

babelfish-for-postgresql / babelfish_extensions / 12652337012 / 1 75% BABEL_5_X_DEV: 77%

README BADGES x

Markdown

Textile

RDoc

HTML

Rst

Source Files on job 12652337012.1

babelfish-for-postgresql / babelfish_extensions / 12652337012 / 1
75%
BABEL_5_X_DEV: 77%

README BADGES
x