RECHUNK

SQreamDB is the most efficient for processing large data chunks. The rechunk function improves performance when handling tables with small data chunks by allowing you to consolidate these small chunks into larger ones. This function also handles mixed chunks, which include one or more deleted records and/or records marked for deletion but not yet purged (i.e., awaiting the removal of deleted data). When applied to mixed chunks, the function performs a cleanup operation, resulting in clean, large data chunks.

Syntax

SELECT rechunk('<schema_name>', '<table_name>')

Parameters

Parameter	Description
`schema_name`	The name of the schema in which the table to rechunk is in
`table_name`	The name of the table to rechunk

Example

SELECT rechunk('public', 't');

Permissions

Using the rechunk command requires no special permissions.