Grouper Users - Open Discussion List

[Robert Bradley <>]

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

Attachment: signature.asc
Description: OpenPGP digital signature