-werners-
Esteemed Contributor III

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.

View solution in original post