Compare TimescaleDB editions

The following versions of TimescaleDB are available:

• TimescaleDB Apache 2 Edition
• TimescaleDB Community Edition

Your use of either TimescaleDB Apache 2 Edition or TimescaleDB Community Edition is governed by our Privacy Policy.

Check your installed edition

If you are already running TimescaleDB, check your edition with this command:

SHOW timescaledb.license;

This returns either timescale (TimescaleDB Community Edition features enabled, the default) or apache (Apache 2-only mode).

For more detail, query pg_settings:

SELECT name, setting, source, sourcefile, sourceline
FROM pg_settings
WHERE name = 'timescaledb.license';

This is more informative because it tells you:

• setting: the current value, timescale or apache.
• source: where it was set, such as the default, a configuration file, or the session.
• sourcefile and sourceline: which configuration file and line it came from, if applicable.

TimescaleDB Apache 2 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

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

For more information about the Tiger Data 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.

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	❌	✅
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_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.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	✅	✅