TimescaleDB editions

The following versions of TimescaleDB are available:

• TimescaleDB Apache 2 Edition
• TimescaleDB Community Edition

TimescaleDB Apache 2 Edition is available under the Apache 2.0 license. This is a classic open source license, meaning that it is completely unrestricted - anyone can take this code and offer it as a service.

You can install TimescaleDB Apache 2 Edition on your own on-premises or cloud infrastructure and run it for free.

You can sell TimescaleDB Apache 2 Edition as a service, even if you're not the main contributor.

You can modify the TimescaleDB Apache 2 Edition source code and run it for production use.

TimescaleDB Community Edition is the advanced, best, and most feature complete version of TimescaleDB, available under the terms of the TigerData License (TSL).

For more information about the TigerData license, see this blog post.

Many of the most recent features of TimescaleDB are only available in TimescaleDB Community Edition.

You can install TimescaleDB Community Edition in your own on-premises or cloud infrastructure and run it for free. TimescaleDB Community Edition is completely free if you manage your own service.

You cannot sell TimescaleDB Community Edition as a service, even if you are the main contributor.

You can modify the TimescaleDB Community Edition source code and run it for production use. Developers using TimescaleDB Community Edition have the "right to repair" and make modifications to the source code and run it in their own on-premises or cloud infrastructure. However, you cannot make modifications to the TimescaleDB Community Edition source code and offer it as a service.

You can access a hosted version of TimescaleDB Community Edition through Tiger Cloud, a cloud-native platform for time-series and real-time analytics.

Features	TimescaleDB Apache 2 Edition	TimescaleDB Community Edition
Hypertables and chunks
CREATE TABLE	✅	✅
create_hypertable	✅	✅
show_chunks	✅	✅
drop_chunks	✅	✅
split_chunk	❌	✅
reorder_chunk	❌	✅
move_chunk	❌	✅
add_reorder_policy	❌	✅
attach_tablespace	✅	✅
detach_tablespace()	✅	✅
detach_tablespaces()	✅	✅
show_tablespaces	✅	✅
set_chunk_time_interval	✅	✅
set_integer_now_func	✅	✅
add_dimension()	✅	✅
create_index (Transaction Per Chunk)	✅	✅
hypertable_size	✅	✅
hypertable_detailed_size	✅	✅
hypertable_index_size	✅	✅
chunks_detailed_size	✅	✅
Distributed hypertables: This feature is deprecated in all editions after TimescaleDB v2.13.
Hypercore Since TimescaleDB v2.18.0
ALTER MATERIALIZED VIEW (Hypercore)	❌	✅
ALTER TABLE (Hypercore)	❌	✅
add_columnstore_policy	❌	✅
remove_columnstore_policy	❌	✅
convert_to_columnstore	❌	✅
convert_to_rowstore	❌	✅
hypertable_columnstore_settings	❌	✅
hypertable_columnstore_stats	❌	✅
chunk_columnstore_settings	❌	✅
chunk_columnstore_stats	❌	✅
Continuous aggregates
CREATE MATERIALIZED VIEW (Continuous Aggregate)	❌	✅
ALTER MATERIALIZED VIEW (Continuous Aggregate)	❌	✅
DROP MATERIALIZED VIEW (Continuous Aggregate)	❌	✅
add_continuous_aggregate_policy()	❌	✅
refresh_continuous_aggregate	❌	✅
remove_continuous_aggregate_policy()	❌	✅
Data retention
add_retention_policy	❌	✅
remove_retention_policy	❌	✅
Jobs and automation
add_job	❌	✅
alter_job	❌	✅
delete_job	❌	✅
run_job	❌	✅
Hyperfunctions
approximate_row_count	✅	✅
first	✅	✅
last	✅	✅
histogram	✅	✅
time_bucket	✅	✅
time_bucket_ng (experimental feature)	✅	✅
time_bucket_gapfill	❌	✅
locf	❌	✅
interpolate	❌	✅
percentile_agg	❌	✅
approx_percentile	❌	✅
approx_percentile_rank	❌	✅
rollup	❌	✅
max_val	❌	✅
mean	❌	✅
error	❌	✅
min_val	❌	✅
num_vals	❌	✅
uddsketch	❌	✅
tdigest	❌	✅
time_weight	❌	✅
rollup	❌	✅
average	❌	✅
Informational Views
timescaledb_information.chunks	✅	✅
timescaledb_information.continuous_aggregates	✅	✅
timescaledb_information.compression_settings	✅	✅
timescaledb_information.data_nodes	✅	✅
timescaledb_information.dimension	✅	✅
timescaledb_information.hypertables	✅	✅
timescaledb_information.jobs	✅	✅
timescaledb_information.job_stats	✅	✅
Administration functions
timescaledb_pre_restore	✅	✅
timescaledb_post_restore	✅	✅
get_telemetry_report	✅	✅
dump_meta_data	✅	✅
Compression Old API since TimescaleDB v2.18.0 replaced by Hypercore
ALTER TABLE (Compression)	❌	✅
add_compression_policy	❌	✅
remove_compression_policy	❌	✅
compress_chunk	❌	✅
decompress_chunk	❌	✅
hypertable_compression_stats	❌	✅
chunk_compression_stats	❌	✅