Skip to content

Feature comparison

Choose where to run TimescaleDB, and compare features and operational effort across deployments

TimescaleDB is the core engine in every Tiger Data product. What differs is where it runs and who operates it.

  • If your data can live on infrastructure Tiger Data operates, choose Tiger Cloud, on AWS or Azure depending on the integrations you need.
  • If it must stay on infrastructure you control, TimescaleDB Enterprise gives you the operations of a managed service there.
  • If you want the engine alone and build the operations around it, choose TimescaleDB Community Edition.
Important

TimescaleDB Enterprise is in public beta. Start a free trial to try it on your own servers.

Below is a feature-by-feature comparison of the four deployments. ✅ means the deployment provides and operates the feature for you, Manual means it is reachable but you build and run it yourself, and ❌ means it is not available.

PostgreSQL performance
FeatureTiger Cloud on AWSTiger Cloud on AzureTimescaleDB EnterpriseSelf-hosted TimescaleDB
Automatic partitioning via hypertables for efficient indexes and faster ingest✅✅✅✅
Continuous aggregates✅✅✅✅
Time/partition-oriented constraint exclusion for faster queries✅✅✅✅
Skip scans, ordered appends, custom optimizations for faster LIMIT and DISTINCT queries✅✅✅✅
Columnar storage for accelerated scans✅✅✅✅
Vectorized query execution (SIMD)✅✅✅✅
Specialized vector indexes for AI applications✅✅✅Manual
Source connectorsPostgreSQL, Amazon S3, Apache KafkaPostgreSQL, Apache KafkaPostgreSQLManual
Destination connectorsApache IcebergApache IcebergLivesync to another service or Tiger CloudManual
In-Console CSV, Parquet, and text file imports✅❌❌❌

Flexible analysis with full SQL
FeatureTiger Cloud on AWSTiger Cloud on AzureTimescaleDB EnterpriseSelf-hosted TimescaleDB
Complete PostgreSQL ecosystem (all PostgreSQL features, connectors, third-party drivers)✅✅✅✅
Cross-table JOINs for time-series and events with relational tables✅✅✅✅
Rich timestamp and timezone support✅✅✅✅
Flexible time-bucketing for time-oriented analysis✅✅✅✅
Advanced hyperfunctions (gapfilling, interpolation, histograms)✅✅✅✅
Geospatial and vector data types✅✅✅✅

Automated data management
FeatureTiger Cloud on AWSTiger Cloud on AzureTimescaleDB EnterpriseSelf-hosted TimescaleDB
Columnstore compression (up to 98% storage savings)✅✅✅✅
Data retention policies✅✅✅✅
Data tiering with automated policies✅✅❌❌
Data reordering for efficient disk scans✅✅✅✅
Data downsampling for efficient historical analysis✅✅✅✅
Background job scheduler and user-defined jobs✅✅✅✅
Automated chunk interval tuning✅✅❌❌

Scaling and resource management
FeatureTiger Cloud on AWSTiger Cloud on AzureTimescaleDB EnterpriseSelf-hosted TimescaleDB
Disaggregated compute and storage✅✅❌❌
Dynamic compute resizing✅✅Manual❌
Dynamic disk storage with usage-based pricing✅✅❌❌
Dynamic I/O provisioning for high-read/high-write performance✅✅ManualManual
Low-cost storage with infinite capacity✅✅❌❌
Read scalingRead replicas with load balancingRead replicas with load balancingDirect read-only connections to HA replicasManual
Connection pooling for connection scaling✅✅✅Manual
Automated resource-aware parameter tuning✅✅✅❌
Terraform for infrastructure-as-code control✅✅❌❌
Management interfacesConsole, REST API, CLI, Tiger MCPConsole, REST API, CLI, Tiger MCPConsole, REST APIManual

High availability and reliability
FeatureTiger Cloud on AWSTiger Cloud on AzureTimescaleDB EnterpriseSelf-hosted TimescaleDB
High availability deploymentMulti-AZMulti-AZMulti-node across separate hostsManual
BackupsContinuous incremental, automatedContinuous incremental, automatedFull and differential, scheduledManual
Cross-region backup and restore✅✅ManualManual
Point-in-time recovery and forking✅✅✅Manual
Configurable backup retentionUp to 180 daysUp to 180 daysUp to 100 days or 100 backupsManual
Regular database and disk snapshots for fast restore✅✅ManualManual
Rapid recovery (fast database restart, remote disk remount)✅✅❌❌
Memory guard protections to avoid out-of-memory crashes✅✅❌❌
Decoupled control/data planes for greater resilience✅✅✅❌
Commercial SLAs✅✅Contact salesContact sales

Upgrades and patching
FeatureTiger Cloud on AWSTiger Cloud on AzureTimescaleDB EnterpriseSelf-hosted TimescaleDB
Automated upgrades during maintenance windows✅✅❌❌
Phased, zero-downtime TimescaleDB and PostgreSQL minor upgrades✅✅Rolling, one switchover❌
PostgreSQL major version upgrades with forking workflow and disk snapshots✅✅pg_upgrade from the console❌
HA-replica-aware coordinated upgrades✅✅✅❌
Fleet-wide version and stability monitoring with staged roll-out/roll-back✅✅❌❌

Security and compliance
FeatureTiger Cloud on AWSTiger Cloud on AzureTimescaleDB EnterpriseSelf-hosted TimescaleDB
Runs on infrastructure you control, including air-gapped networks❌❌✅✅
Data encryption at rest (disk and backup)✅✅ManualManual
Data encryption in transit✅✅✅Manual
Database SSL with fully verifiable certificate chains✅✅ManualManual
Control plane role-based access control✅✅✅❌
Database role-based access control✅✅✅✅
Multi-factor authentication✅✅✅❌
Corporate SSO and SAML✅✅OIDC❌
Enforce MFA or SSO for all project members✅✅✅❌
IP allow lists✅✅✅Manual
Private connectivity to your cloud networkAWS PrivateLink, Transit Gateway, VPC peeringAzure Private Link❌❌
Layered database privilege escalation protections✅✅❌❌
Vulnerability scanning and third-party pen testing✅✅❌❌

Observability
FeatureTiger Cloud on AWSTiger Cloud on AzureTimescaleDB EnterpriseSelf-hosted TimescaleDB
Operational database visibility (performance, regressions, optimization)✅✅✅Manual
Automated query analysis and statistics✅✅ManualManual
Per-query drill-downs (execution times, row results, plans, memory, cache)✅✅ManualManual
In-Console metric visualization and system logs✅✅✅❌
Metric exportersCloudWatch, Prometheus, DatadogAzure Monitor, Prometheus, DatadogPrometheusManual
Connection visibilityMonitoring and managementMonitoring and managementMonitoringManual

Support and operations
FeatureTiger Cloud on AWSTiger Cloud on AzureTimescaleDB EnterpriseSelf-hosted TimescaleDB
24/7 follow-the-sun support (APAC, EMEA, Americas)✅✅Contact salesContact sales
Production support (severity 1)✅✅Contact salesContact sales
Architectural reviews, data modeling, query optimization, migration support✅✅Contact salesContact sales
24/7 operational monitoring and control✅✅Contact salesContact sales
98%+ customer satisfaction (CSAT scores)✅✅Contact salesContact sales

Choosing a deployment
  • Tiger Cloud on AWS: Full feature set, including AWS-specific integrations. Private connectivity through AWS PrivateLink, Transit Gateway, and VPC peering, cross-region backup and restore, an Amazon S3 source connector, and metric export to CloudWatch (as well as Prometheus and Datadog).
  • Tiger Cloud on Azure: The same core database and management platform. Private connectivity through Azure Private Link, cross-region backup and restore, and metric export to Azure Monitor (as well as Prometheus and Datadog). Some AWS-specific integrations, such as the S3 source connector, VPC peering, and CloudWatch, are not yet available.
  • TimescaleDB Enterprise: The operations of a managed service on infrastructure you control: on-premises, edge, air-gapped, or your own cloud account. A console on your own network provides automatic HA failover, full and differential backups with point-in-time recovery, and built-in monitoring. Support and licensing terms are available by contacting sales. See Meet TimescaleDB Enterprise.
  • Self-hosted TimescaleDB: Full SQL and time-series capabilities. You manage backups, high availability, scaling, and observability yourself. For managed operations on your own infrastructure, see TimescaleDB Enterprise. Enterprise support is available by contacting sales.