[midPoint] GIN Indexes in midPoint

[Haywood, Jeremiah]

Hello all,

 

We recently discovered some performance issues that were caused by queries
in Midpoint using the LIKE statement. One being the basic user search in the
UI and a couple being internal queries we had in the user template. Working
with our DBA team we've discussed the potential of putting GIN indexes on a
few fields to improve performance. Has anyone else used GIN indexes in
midPoint to help with query performance?

 

Thank you,

 

Jeremiah Haywood

Lead IAM Administrator

Office of Technology Solutions | Illinois State University

Phone Number (309) 438-3829

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.evolveum.com/pipermail/midpoint/attachments/20230623/66523bc3/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 7264 bytes
Desc: not available
URL: <https://lists.evolveum.com/pipermail/midpoint/attachments/20230623/66523bc3/attachment.bin>