v.21.10Improvements

Improve ALTER ... MATERIALIZE TTL by Metadata Recalculation Only

Improve ALTER ... MATERIALIZE TTL by recalculating metadata only without actual TTL action. #27019 (lthaooo).
Improves the ALTER ... MATERIALIZE TTL command to allow recalculating TTL metadata without performing the actual TTL actions on data.

Why it matters

This feature addresses the need to update TTL metadata (such as recalculating TTL expressions) without triggering the execution of TTL data modifications. It helps users maintain accurate TTL metadata while avoiding immediate changes to the stored data, providing better control and efficiency.

How to use it

Use the ALTER TABLE ... MATERIALIZE TTL command as usual. With this improvement, the command now recalculates TTL metadata only, skipping actual TTL actions, ensuring metadata consistency without affecting data immediately.