Compare TimescaleDB editions

See the difference between the TimescaleDB Community and TimescaleDB Apache 2 editions

The following versions of are available:

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 on your own on-premises or cloud infrastructure and run it for free.

You can sell as a service, even if you’re not the main contributor.

You can modify the source code and run it for production use.

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

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

Many of the most recent features of are only available in .

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

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

You can modify the source code and run it for production use. Developers using 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 source code and offer it as a service.

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

Feature comparison

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	✅	✅
SkipScan	❌	✅
Distributed hypertables: sunsetted in TimescaleDB v2.14.x	❌	❌
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 replaced by Hypercore
ALTER TABLE (Compression)	❌	✅
add_compression_policy	❌	✅
remove_compression_policy	❌	✅
compress_chunk	❌	✅
decompress_chunk	❌	✅
hypertable_compression_stats	❌	✅
chunk_compression_stats	❌	✅