Closed Felixoid closed 4 years ago
@Felixoid, to comply with the statement
-- modified_at < (now() - @Interval): we want to merge active partitions only once per interval, -- so do not touch partitions with current active inserts
shouldn't p.modification_time be maxed?
If it would be max, we won't touch partitions with rare inserts. The idea is having them merged eventually too, but at most once per interval.
It tells, that
The active partitions won't be optimized more than once per this interval, seconds
, but:@Interval
option with maximum age for the current retention. The line should be deleted, then allparts > 1
will proceed.