--- title: Feature comparison | Tiger Data Docs description: Compare features across Tiger Cloud on AWS, Tiger Cloud on Azure, and self-hosted TimescaleDB --- This page compares the features available in **Tiger Cloud on AWS**, **Tiger Cloud on Azure**, and **self-hosted TimescaleDB Community Edition**. **Best-in-class PostgreSQL performance** | Feature | Tiger Cloud on AWS | Tiger Cloud on Azure | 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 | ✅ | ✅ | ✅ | | Source connectors | [PostgreSQL](/docs/integrate/connectors/source/sync-from-postgres/index.md), [Amazon S3](/docs/integrate/connectors/source/sync-from-s3/index.md), [Apache Kafka](/docs/integrate/connectors/source/sync-from-kafka/index.md) | [PostgreSQL](/docs/integrate/connectors/source/sync-from-postgres/index.md), [Apache Kafka](/docs/integrate/connectors/source/sync-from-kafka/index.md) | Manual | | Destination connectors | [Iceberg on S3 Tables](/docs/integrate/connectors/destination/tigerlake/index.md) | ❌ | ❌ | | In-Console CSV, Parquet, and text file imports | ✅ | ❌ | ❌ | --- **Flexible analysis with full SQL** | Feature | Tiger Cloud on AWS | Tiger Cloud on Azure | 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 (interpolation, approximation, visualization) | ✅ | ✅ | ✅ | | Geospatial and vector data types | ✅ | ✅ | ✅ | --- **Automated data management** | Feature | Tiger Cloud on AWS | Tiger Cloud on Azure | 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 | ✅ | ✅ | ❌ | --- **Enterprise scalability** | Feature | Tiger Cloud on AWS | Tiger Cloud on Azure | Self-hosted TimescaleDB | | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | :----------------: | :------------------: | :---------------------: | | Disaggregated compute and storage | ✅ | ✅ | Manual | | Dynamic compute resizing | ✅ | ✅ | ❌ | | Dynamic disk storage with usage-based pricing | ✅ | ✅ | ❌ | | Dynamic I/O provisioning for high-read/high-write performance | ✅ | ✅ | Manual | | Low-cost storage with infinite capacity | ✅ | ✅ | ❌ | | Transparent queries across high-performance and low-cost tiers | ✅ | ✅ | ❌ | | Read replicas with load balancing for seamless read scaling | ✅ | ✅ | Manual | | Connection pooling for connection scaling | ✅ | ✅ | Manual | | Automated resource-aware parameter tuning | ✅ | ✅ | ❌ | | Terraform for infrastructure-as-code control | ✅ | ✅ | ❌ | | Management interfaces ([Console](/docs/deploy/tiger-cloud/tiger-cloud-aws/service-management/service-overview/index.md), [REST API](/docs/reference/tiger-cloud-rest/index.md), [CLI](/docs/reference/tiger-cloud/tiger-cli/index.md), [Tiger MCP](/docs/get-started/quickstart/mcp-cli/index.md)) | ✅ | ✅ | ❌ | --- **High availability and reliability** | Feature | Tiger Cloud on AWS | Tiger Cloud on Azure | Self-hosted TimescaleDB | | ----------------------------------------------------------- | :----------------: | :------------------: | :---------------------: | | Multi-AZ deployments for high availability | ✅ | ✅ | Manual | | Continuous incremental backup and automated restore | ✅ | ✅ | Manual | | Cross-region backup and restore | ✅ | ✅ | ❌ | | Point-in-time recovery and forking | ✅ | ✅ | Manual | | Regular database and disk snapshots for fast restore | ✅ | ✅ | ❌ | | 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 | ✅ | ✅ | ❌ | --- **Automated upgrades and software patching** | Feature | Tiger Cloud on AWS | Tiger Cloud on Azure | Self-hosted TimescaleDB | | -------------------------------------------------------------------------- | :----------------: | :------------------: | :---------------------: | | Automated upgrades during maintenance windows | ✅ | ✅ | ❌ | | Phased, zero-downtime TimescaleDB and PostgreSQL minor upgrades | ✅ | ✅ | ❌ | | PostgreSQL major version upgrades with forking workflow and disk snapshots | ✅ | ✅ | ❌ | | 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 | Self-hosted TimescaleDB | | ------------------------------------------------------------ | :-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------: | :--------------------------------------------------------------------------------------------------: | :---------------------: | | SOC 2 Type 2, GDPR, HIPAA certified compliance | ✅ | ✅ | ❌ | | Data encryption at rest (disk and backup) | ✅ | ✅ | Manual | | Data encryption in transit | ✅ | ✅ | Manual | | Database SSL with fully verifiable certificate chains | ✅ | ✅ | ❌ | | Control plane role-based access control | ✅ | ✅ | ❌ | | Database role-based access control | ✅ | ✅ | ✅ | | Multi-factor authentication | ✅ | ✅ | ❌ | | Corporate SSO and SAML | ✅ | ✅ | ❌ | | Enforce MFA or SSO for all project members | ✅ | ✅ | ❌ | | IP allow lists | ✅ | ✅ | Manual | | Private connectivity to your cloud network | [AWS PrivateLink](/docs/deploy/tiger-cloud/tiger-cloud-aws/security/aws-privatelink/index.md), [Transit Gateway](/docs/deploy/tiger-cloud/tiger-cloud-aws/security/transit-gateway/index.md), [VPC peering](/docs/deploy/tiger-cloud/tiger-cloud-aws/security/vpc/index.md) | [Azure Private Link](/docs/deploy/tiger-cloud/tiger-cloud-azure/security/azure-privatelink/index.md) | ❌ | | Layered database privilege escalation protections | ✅ | ✅ | ❌ | | Secure SDLC, vulnerability scanning, third-party pen testing | ✅ | ✅ | ❌ | --- **Deep observability** | Feature | Tiger Cloud on AWS | Tiger Cloud on Azure | Self-hosted TimescaleDB | | -------------------------------------------------------------------------- | :--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------: | :--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------: | :---------------------: | | Operational database visibility (performance, regressions, optimization) | ✅ | ✅ | ❌ | | Automated query analysis and statistics | ✅ | ✅ | ❌ | | Per-query drill-downs (execution times, row results, plans, memory, cache) | ✅ | ✅ | ❌ | | In-Console metric visualization and system logs | ✅ | ✅ | ❌ | | Metric exporters | [CloudWatch](/docs/integrate/observability-alerting/cloudwatch/index.md), [Prometheus](/docs/integrate/observability-alerting/prometheus/index.md), [Datadog](/docs/integrate/observability-alerting/datadog/index.md) | [Azure Monitor](/docs/integrate/observability-alerting/azure-monitor/index.md), [Prometheus](/docs/integrate/observability-alerting/prometheus/index.md), [Datadog](/docs/integrate/observability-alerting/datadog/index.md) | ❌ | | Connection monitoring and management | ✅ | ✅ | Manual | --- **Production-grade support and operations** | Feature | Tiger Cloud on AWS | Tiger Cloud on Azure | Self-hosted TimescaleDB | | --------------------------------------------------------------------------- | :----------------: | :------------------: | :-----------------------------------------: | | 24/7 follow-the-sun support (APAC, EMEA, Americas) | ✅ | ✅ | [Contact sales](mailto:sales@tigerdata.com) | | Production support (severity 1) | ✅ | ✅ | [Contact sales](mailto:sales@tigerdata.com) | | Architectural reviews, data modeling, query optimization, migration support | ✅ | ✅ | [Contact sales](mailto:sales@tigerdata.com) | | 24/7 operational monitoring and control | ✅ | ✅ | [Contact sales](mailto:sales@tigerdata.com) | | 98%+ customer satisfaction (CSAT scores) | ✅ | ✅ | [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, an Iceberg destination connector for S3 Tables, 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 and Iceberg connectors, VPC peering, and CloudWatch, are not yet available. - **Self-hosted TimescaleDB**: Full SQL and time-series capabilities. You manage backups, high availability, scaling, and observability yourself. Managed operations and enterprise support are available by [contacting sales](mailto:sales@tigerdata.com).