The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
Auto purge
Hello,
How to purge automatically when it reaches count to 1crore?
1
Comments
I have the same problem what we do?
Hi,
Are you asking how to purge a table when you have a row count of 10 million, or purge when you've deleted 10 million records, or something else? The question is a bit vague
It should be automatically purged when deleted count reaches to 10 million across all tables, every time it should be less than 1 million
Vertica provides two methods for determining when deleted data is eligible to be purged:
If you want to purge based on delete vector row counts, you can set up a cron job that runs every so often that issues a purge command when the dv row counts >= 10 million.