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
Automatically purging table does not work
Moderator: NorbertKrupa
Re: Automatically purging table does not work
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
—Sharon
Sharon Cutter
Vertica Consultant, Zazz Technologies LLC
Vertica Consultant, Zazz Technologies LLC