Purge does not remove deleted data
I am using 7.1.2 and i purge tables having highest deleted data , i purge the data but deleted data does not go away.
Step 1. SELECT schema_name
,(sum(deleted_row_count) / sum(total_row_count) * 100)::INT per_del_rows
WHERE node_name = ( SELECT local_node_name())
GROUP BY 1, 2
HAVING sum(deleted_row_count) > 0
ORDER BY 6 DESC;
step 2. select make_ahm_now();
step 3. vertify AHM
step 4. purge table corresponding to projections which have high deleted rows
when i check deleted rows for tables for which i purged it shows the same deleted rows count.
it happens only for some tables