Bug #18490
Updated by Ward Vandewege over 2 years ago
Postgres seems to be creating a lot of fragmentation in the materialized_permissions table in a context with a lot of users (~1000) and large groups.
The group sync script is very slow in this context while there are other updates ongoing.
Vacuum full helps but can often not complete because normal usage patterns prevent it from completing.
This has been observed on Postgres 9.5 and 13.