index.mdx

title	Hypercore
sidebar	label Overview
description	Reference information about the TimescaleDB hybrid row-columnar storage engine
products	cloud self_hosted
keywords	hypercore

import * as C from "@constants";

import HypercoreIntro from '@partials/_hypercore-intro.mdx'; import HCPolicyWorkflow from '@partials/_hypercore_policy_workflow.mdx';

Samples

Limitations

{C.CHUNK}s in the {C.COLUMNSTORE} have the following limitations:

• ROW LEVEL SECURITY is not supported on {C.CHUNK}s in the {C.COLUMNSTORE}.

Available functions

Policies

• add_columnstore_policy(): set a policy to automatically move {C.CHUNK}s in a {C.HYPERTABLE} to the {C.COLUMNSTORE} when they reach a given age
• remove_columnstore_policy(): remove a {C.COLUMNSTORE} policy from a {C.HYPERTABLE}
• add_compaction_policy(): set a policy to automatically compact unordered {C.CHUNK}s in the {C.COLUMNSTORE}
• remove_compaction_policy(): remove a compaction policy from a {C.HYPERTABLE}

Configuration

• ALTER TABLE (hypercore): enable the {C.COLUMNSTORE} for a {C.HYPERTABLE}

Manual conversion

• convert_to_columnstore(): manually add a {C.CHUNK} to the {C.COLUMNSTORE}
• convert_to_rowstore(): move a {C.CHUNK} from the {C.COLUMNSTORE} to the {C.ROWSTORE}

Statistics and information

• chunk_columnstore_stats(): get statistics about {C.CHUNK}s in the {C.COLUMNSTORE}
• hypertable_columnstore_stats(): get {C.COLUMNSTORE} statistics related to the

{C.COLUMNSTORE}

• timescaledb_information.chunk_columnstore_settings: get information about settings on each {C.CHUNK} in the {C.COLUMNSTORE}
• timescaledb_information.hypertable_columnstore_settings: get information about {C.COLUMNSTORE} settings for all {C.HYPERTABLE}s