IdStory Identity Manager

I synchronized 18 000 tree nodes and in the end, the size of the DB table idm_forest_index was 17 GB. After manually running "vacuum full idm_forest_index", the size decreased to 8 MB.

Tested on the version 7.8.5 on Windows. Test CSV with the organizations structure is attached.
In my local environment, I got to 4 GB for 9 000 tree nodes.

It would be nice to look into it when there is time.

SQL script to get the Size and its metadata of the table (my local environment):

SELECT
   relname as "Table",
   pg_size_pretty(pg_total_relation_size(relid)) As "Size",
   pg_size_pretty(pg_total_relation_size(relid) - pg_relation_size(relid)) as "External Size" 
   FROM pg_catalog.pg_statio_user_tables ORDER BY pg_total_relation_size(relid) DESC;
              Table                |    Size    | External Size 
------------------------------------+------------+---------------
idm_forest_index                   | 4673 MB    | 3049 MB

VACUUM FULL idm_forest_index;

idm_forest_index                   | 3280 kB    | 2144 kB