Code: Select all
SELECT (SELECT SUM(used_bytes)
FROM v_monitor.delete_vectors) / (SELECT SUM(ros_used_bytes)
FROM v_monitor.projection_storage) * 100 AS percent;
I know that there is high IO cost for running a purge, but what if it's run every hour for example? Since the delete vectors are still considered when the query is run, it makes sense that running purge frequently could be a potential benefit of speeding up queries.