---
title: Feature comparison | Tiger Data Docs
description: 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](https://www.tigerdata.com/timescaledb-enterprise#form) 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**

| Feature                                                                                 |                                                                                               Tiger Cloud on AWS                                                                                               |                                                              Tiger Cloud on Azure                                                             |                                    TimescaleDB Enterprise                                    | Self-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 connectors                                                                       | [PostgreSQL](/integrate/connectors/source/sync-from-postgres/index.md), [Amazon S3](/integrate/connectors/source/sync-from-s3/index.md), [Apache Kafka](/integrate/connectors/source/sync-from-kafka/index.md) | [PostgreSQL](/integrate/connectors/source/sync-from-postgres/index.md), [Apache Kafka](/integrate/connectors/source/sync-from-kafka/index.md) |                 [PostgreSQL](https://enterprise.tigerdata.com/docs/livesync)                 |          Manual         |
| Destination connectors                                                                  |                                                                     [Apache Iceberg](/integrate/connectors/destination/tigerlake/index.md)                                                                     |                                     [Apache Iceberg](/integrate/connectors/destination/tigerlake/index.md)                                    | [Livesync](https://enterprise.tigerdata.com/docs/livesync) to another service or Tiger Cloud |          Manual         |
| In-Console CSV, Parquet, and text file imports                                          |                                                                                                        ✅                                                                                                       |                                                                       ❌                                                                       |                                               ❌                                              |            ❌            |

---

**Flexible analysis with full SQL**

| Feature                                                                                  | Tiger Cloud on AWS | Tiger Cloud on Azure | TimescaleDB Enterprise | Self-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**

| Feature                                             | Tiger Cloud on AWS | Tiger Cloud on Azure | TimescaleDB Enterprise | Self-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**

| Feature                                                       |                                                                                                                   Tiger Cloud on AWS                                                                                                                   |                                                                                                                  Tiger Cloud on Azure                                                                                                                  |                                             TimescaleDB Enterprise                                            | Self-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 |                                                                                                                            ✅                                                                                                                           |                                                                                                                            ✅                                                                                                                           |                                                     Manual                                                    |          Manual         |
| Low-cost storage with infinite capacity                       |                                                                                                                            ✅                                                                                                                           |                                                                                                                            ✅                                                                                                                           |                                                       ❌                                                       |            ❌            |
| Read scaling                                                  |                                                                                                            Read replicas with load balancing                                                                                                           |                                                                                                            Read replicas with load balancing                                                                                                           |                                  Direct read-only connections to HA replicas                                  |          Manual         |
| Connection pooling for connection scaling                     |                                                                                                                            ✅                                                                                                                           |                                                                                                                            ✅                                                                                                                           |                                                       ✅                                                       |          Manual         |
| Automated resource-aware parameter tuning                     |                                                                                                                            ✅                                                                                                                           |                                                                                                                            ✅                                                                                                                           |                                                       ✅                                                       |            ❌            |
| Terraform for infrastructure-as-code control                  |                                                                                                                            ✅                                                                                                                           |                                                                                                                            ✅                                                                                                                           |                                                       ❌                                                       |            ❌            |
| Management interfaces                                         | [Console](/deploy/tiger-cloud/tiger-cloud-aws/service-management/service-overview/index.md), [REST API](/reference/tiger-cloud-rest/index.md), [CLI](/reference/tiger-cloud/tiger-cli/index.md), [Tiger MCP](/get-started/quickstart/mcp-cli/index.md) | [Console](/deploy/tiger-cloud/tiger-cloud-aws/service-management/service-overview/index.md), [REST API](/reference/tiger-cloud-rest/index.md), [CLI](/reference/tiger-cloud/tiger-cli/index.md), [Tiger MCP](/get-started/quickstart/mcp-cli/index.md) | [Console](https://enterprise.tigerdata.com/docs), [REST API](https://enterprise.tigerdata.com/docs/reference) |          Manual         |

---

**High availability and reliability**

| Feature                                                     |         Tiger Cloud on AWS        |        Tiger Cloud on Azure       |            TimescaleDB Enterprise           |           Self-hosted TimescaleDB           |
| ----------------------------------------------------------- | :-------------------------------: | :-------------------------------: | :-----------------------------------------: | :-----------------------------------------: |
| High availability deployment                                |              Multi-AZ             |              Multi-AZ             |       Multi-node across separate hosts      |                    Manual                   |
| Backups                                                     | Continuous incremental, automated | Continuous incremental, automated |       Full and differential, scheduled      |                    Manual                   |
| Cross-region backup and restore                             |                 ✅                 |                 ✅                 |                    Manual                   |                    Manual                   |
| Point-in-time recovery and forking                          |                 ✅                 |                 ✅                 |                      ✅                      |                    Manual                   |
| Configurable backup retention                               |           Up to 180 days          |           Up to 180 days          |        Up to 100 days or 100 backups        |                    Manual                   |
| Regular database and disk snapshots for fast restore        |                 ✅                 |                 ✅                 |                    Manual                   |                    Manual                   |
| 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 sales](mailto:sales@tigerdata.com) | [Contact sales](mailto:sales@tigerdata.com) |

---

**Upgrades and patching**

| Feature                                                                    | Tiger Cloud on AWS | Tiger Cloud on Azure |     TimescaleDB Enterprise    | Self-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**

| Feature                                                           |                                                                                                                      Tiger Cloud on AWS                                                                                                                      |                                       Tiger Cloud on Azure                                      | TimescaleDB Enterprise | Self-hosted TimescaleDB |
| ----------------------------------------------------------------- | :----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------: | :---------------------------------------------------------------------------------------------: | :--------------------: | :---------------------: |
| Runs on infrastructure you control, including air-gapped networks |                                                                                                                               ❌                                                                                                                              |                                                ❌                                                |            ✅           |            ✅            |
| Data encryption at rest (disk and backup)                         |                                                                                                                               ✅                                                                                                                              |                                                ✅                                                |         Manual         |          Manual         |
| Data encryption in transit                                        |                                                                                                                               ✅                                                                                                                              |                                                ✅                                                |            ✅           |          Manual         |
| Database SSL with fully verifiable certificate chains             |                                                                                                                               ✅                                                                                                                              |                                                ✅                                                |         Manual         |          Manual         |
| 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 network                        | [AWS PrivateLink](/deploy/tiger-cloud/tiger-cloud-aws/security/aws-privatelink/index.md), [Transit Gateway](/deploy/tiger-cloud/tiger-cloud-aws/security/transit-gateway/index.md), [VPC peering](/deploy/tiger-cloud/tiger-cloud-aws/security/vpc/index.md) | [Azure Private Link](/deploy/tiger-cloud/tiger-cloud-azure/security/azure-privatelink/index.md) |            ❌           |            ❌            |
| Layered database privilege escalation protections                 |                                                                                                                               ✅                                                                                                                              |                                                ✅                                                |            ❌           |            ❌            |
| Vulnerability scanning and third-party pen testing                |                                                                                                                               ✅                                                                                                                              |                                                ✅                                                |            ❌           |            ❌            |

---

**Observability**

| Feature                                                                    |                                                                                            Tiger Cloud on AWS                                                                                           |                                                                                              Tiger Cloud on Azure                                                                                             | TimescaleDB Enterprise | Self-hosted TimescaleDB |
| -------------------------------------------------------------------------- | :-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------: | :-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------: | :--------------------: | :---------------------: |
| Operational database visibility (performance, regressions, optimization)   |                                                                                                    ✅                                                                                                    |                                                                                                       ✅                                                                                                       |            ✅           |          Manual         |
| Automated query analysis and statistics                                    |                                                                                                    ✅                                                                                                    |                                                                                                       ✅                                                                                                       |         Manual         |          Manual         |
| Per-query drill-downs (execution times, row results, plans, memory, cache) |                                                                                                    ✅                                                                                                    |                                                                                                       ✅                                                                                                       |         Manual         |          Manual         |
| In-Console metric visualization and system logs                            |                                                                                                    ✅                                                                                                    |                                                                                                       ✅                                                                                                       |            ✅           |            ❌            |
| Metric exporters                                                           | [CloudWatch](/integrate/observability-alerting/cloudwatch/index.md), [Prometheus](/integrate/observability-alerting/prometheus/index.md), [Datadog](/integrate/observability-alerting/datadog/index.md) | [Azure Monitor](/integrate/observability-alerting/azure-monitor/index.md), [Prometheus](/integrate/observability-alerting/prometheus/index.md), [Datadog](/integrate/observability-alerting/datadog/index.md) |       Prometheus       |          Manual         |
| Connection visibility                                                      |                                                                                        Monitoring and management                                                                                        |                                                                                           Monitoring and management                                                                                           |       Monitoring       |          Manual         |

---

**Support and operations**

| Feature                                                                     | Tiger Cloud on AWS | Tiger Cloud on Azure |            TimescaleDB Enterprise           |           Self-hosted TimescaleDB           |
| --------------------------------------------------------------------------- | :----------------: | :------------------: | :-----------------------------------------: | :-----------------------------------------: |
| 24/7 follow-the-sun support (APAC, EMEA, Americas)                          |          ✅         |           ✅          | [Contact sales](mailto:sales@tigerdata.com) | [Contact sales](mailto:sales@tigerdata.com) |
| Production support (severity 1)                                             |          ✅         |           ✅          | [Contact sales](mailto:sales@tigerdata.com) | [Contact sales](mailto:sales@tigerdata.com) |
| Architectural reviews, data modeling, query optimization, migration support |          ✅         |           ✅          | [Contact sales](mailto:sales@tigerdata.com) | [Contact sales](mailto:sales@tigerdata.com) |
| 24/7 operational monitoring and control                                     |          ✅         |           ✅          | [Contact sales](mailto:sales@tigerdata.com) | [Contact sales](mailto:sales@tigerdata.com) |
| 98%+ customer satisfaction (CSAT scores)                                    |          ✅         |           ✅          | [Contact sales](mailto:sales@tigerdata.com) | [Contact sales](mailto:sales@tigerdata.com) |

---

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](mailto:sales@tigerdata.com). See [Meet TimescaleDB Enterprise](/learn/enterprise/index.md).
- **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](mailto:sales@tigerdata.com).
