Automatically purging table does not work

[aivaras]

What can be the problems that table is not purged automatically?

Table contains 2002000 rows and 244098 rows are deleted. But those rows are never purged.

Current settings:
PurgeMergeoutPercent = 1
MaxMrgOutROSSizeMB = 4096
HistoryRetentionTime = 0
HistoryRetentionEpochs = -1

Current AHM Time show recent data.

select SUM(sc.total_row_count),
SUM(sc.deleted_row_count),
SUM(sc.total_row_count) - SUM(sc.deleted_row_count) actual_row_count
from storage_containers sc

Result:
2246098 | 244098 | 2002000

[scutter]

The built-in purge policy isn’t effective. I advise my clients to do a combination of purging during/after ETL and implementing an automated purge job. You can use purge_table(), or purge_partition() to purge in a more targeted fashion.

—Sharon