[midPoint] GIN Indexes in midPoint

[Richard Richter]

Hi Jeremiah 

You can try GIN index with trigram option, similar to this (change the table, column, etc. of course): 
CREATE INDEX m_case_fullTextInfo_idx ON m_case USING gin (fullTextInfo gin_trgm_ops); 

Measure the query before and after, but LIKE should benefit a lot from TRGM ops. 

Regards 

Richard Richter 
SW engineer 
evolveum.com 



From: "midPoint General Discussion" <midpoint at lists.evolveum.com> 
To: "midPoint General Discussion" <midpoint at lists.evolveum.com> 
Cc: "Jeremiah Haywood" <jhaywo1 at ilstu.edu> 
Sent: Friday, June 23, 2023 5:30:46 PM 
Subject: [midPoint] GIN Indexes in midPoint 



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 



_______________________________________________ 
midPoint mailing list 
midPoint at lists.evolveum.com 
https://lists.evolveum.com/mailman/listinfo/midpoint 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.evolveum.com/pipermail/midpoint/attachments/20230627/13dd1bdc/attachment.htm>