-
Story
-
Resolution: Unresolved
-
Undefined
-
None
-
None
-
None
-
False
-
None
-
False
-
-
-
None
Background: The RBAC and Indexes section of research conducted for ACM-14989 shows optimizations that can be had by moving the RBAC attributes outside of the JSON. This permits converting the composite gin index of the RBAC conditions into a btree index. Moving these attributes out of the JSONB also permit converting other gin indexes into btree indexes.
Acceptance Criteria: RBAC attributes moved out of JSONB and gin indexes converted to btree indexes.
Additional Information: Consideration to be had if reconstructing the JSON field is necessary if we pull out those attributes, or if we just duplicate the values outside of the JSONB.