Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-12-2022 12:47 AM
you will have to define the retention interval when doing the vacuum.
VACUUM table_name [RETAIN num HOURS]
There is also a dry run option.
You can go up to 0 hours. Like that all history is deleted. A maximum value I do not know, for sure 30 days is possible, never tested with more than that.