replace cri computed membership with postgres materialized view

Full rewrite of group parent/child relations computing and computed membership using SQL views

Recomputes all ~170 000 memberships in less than a second in production.

Fixes group children change in admin, the old implementation times out when changing groups with lots of computed memberships.

assigned to @nico

added 1 commit

• a96dc95f - cri_models: replace cri computed membership with postgres materialized view

Compare with previous version

added 1 commit

• 89a364df - cri_models: replace cri computed membership with postgres materialized view

Compare with previous version

added 1 commit

• bda06e81 - cri_models: replace cri computed membership with postgres materialized view

Compare with previous version

added 1 commit

• 188cbef8 - cri_models: replace cri computed membership with postgres materialized view

Compare with previous version

added 1 commit

• 47655614 - cri_models: replace cri computed membership with postgres materialized view

Compare with previous version

added 1 commit

• d3ecc2d9 - cri_models: replace cri computed membership with postgres materialized view

Compare with previous version

added 1 commit

• bca7ebf8 - cri_models: replace cri computed membership with postgres materialized view

Compare with previous version

added 2 commits

• dd51937e - remove cri_legacy
• 4c250b8a - cri_models: replace cri computed membership with postgres materialized view

Compare with previous version

added 10 commits

• 4c250b8a...a9434242 - 9 commits from branch develop
• 0c04534b - cri_models: replace cri computed membership with postgres materialized view

Compare with previous version

marked this merge request as ready

changed the description

added 3 commits

• 0c04534b...18ba7681 - 2 commits from branch develop
• c3c3e74e - cri_models: replace cri computed membership with postgres materialized view

Compare with previous version

approved this merge request

merged