convert_to_columnstore()

manually add a chunk to the columnstore

Since 2.18.0

Manually convert a specific in the to the .

Although convert_to_columnstore gives you more fine-grained control, best practice is to use add_columnstore_policy. You can also add s to the at a specific time running the job associated with your policy manually.

To move a from the back to the , use convert_to_rowstore.

Samples

To convert a single to :

CALL convert_to_columnstore('_timescaledb_internal._hyper_1_2_chunk');

Arguments

Name	Type	Default	Required	Description
chunk	REGCLASS	-	✔	Name of the to add to the .
if_not_columnstore	BOOLEAN	true	✖	Set to false so this job fails with an error rather than a warning if chunk is already in the .
recompress	BOOLEAN	false	✖	Set to true to add a that had more data inserted after being added to the .

Returns

Calls to convert_to_columnstore return:

Column	Type	Description
chunk name or table	REGCLASS or String	The name of the added to the , or a table-like result set with zero or more rows.