v.24.4New Feature

Add SYSTEM UNLOAD PRIMARY KEY to Optimize Memory Usage

Official CH changelog text
Add SYSTEM UNLOAD PRIMARY KEY to free up memory usage for a table's primary key. #62738 (Pablo Marcos).
Introduces the SYSTEM UNLOAD PRIMARY KEY command to allow freeing up memory used by the primary key of a table.

Why it matters

The feature addresses memory management by enabling users to unload the primary key data from memory for a table, which can help reduce memory consumption when the primary key is no longer needed in memory.

How to use it

Users can execute the following command to unload the primary key of a specific table:

SYSTEM UNLOAD PRIMARY KEY FROM <table_name>

Related resources

PreviousNext