Grouper Users - Open Discussion List

[Shilen Patel <>]

Do you need privileges to be in the change log?  If not, then set
changeLog.includeFlattenedPrivileges=false in grouper-loader.properties.

Thanks!

- Shilen

On 4/1/15, 12:18 PM, "Robert Bradley" 
<>
 wrote:

>On 01/04/15 17:16, Robert Bradley wrote:
>> The problem I'm seeing is that when the rules are applied, the
>> change log table size increases massively to 26 million records or
>> more (~11 GB for the table, with changelog indexes of >24 GB).  This
>> caused problems with disk space, but also creates huge multi-day lags
>> in provisioning new group members using PSP until the changelog
>> clears.
>> 
>
>As a followup to my previous email, I have tried the following to
>improve matters slightly, but without much success:
>
>- Reducing changelog retention time from 14 days.
>- Removing the indexes on the string* columns in
>grouper_change_log_entry since the indexes were not being used.  This
>does reduce the disk space used and the rate of increase, but is not a
>full solution.
>- ANALYZE and VACUUM ANALYZE to improve query plans and clean up unused
>space.  This did nothing.
>
>-- 
>Dr Robert Bradley
>Identity and Access Management, IT Services, University of Oxford
>