Skip to content
TimescaleDB - Timeseries database for PostgreSQL Docs
  • TigerData.com
  • Try for free
Get started
Try the key TigerData features
Start coding with TigerData
Create a Tiger Cloud service
About TigerData products
TigerData architecture for real-time analytics
Pricing plans and account management
Changelog
Use TigerData products
Hypertables
Hypercore
Continuous aggregates
Tiger Cloud regions
Tiger Cloud services
Write data
Query data
Time buckets
Schema management
Configuration
Alerting
Data retention
Tiered storage
Hyperfunctions
Metrics and logging
High availability and read scaling
Maintenance and upgrades
Tiger Cloud Postgres extensions
Back up and recover your services
Jobs
Security
Limitations
Integrate data lakes with Tiger Cloud
Troubleshoot TigerData products
Compression (Old API, replaced by hypercore)
About compression
Compression design
Enable a compression policy
Manual compression
Compress continuous aggregates
Modify compressed data
Decompress chunks
Modify a schema
Tutorials
Integrations
API Reference
Import and sync
AI and Vector: pgai on Tiger Cloud
Other deployment options
Find a docs page
Use TigerData products

Compression (Replaced by Hypercore)

Tiger Cloud: Performance, Scale, Enterprise

Self-hosted products

MST

Old API since TimescaleDB v2.18.0 Replaced by hypercore.

Time-series data can be compressed to reduce the amount of storage required, and increase the speed of some queries. This is a cornerstone feature of TimescaleDB. When new data is added to your database, it is in the form of uncompressed rows. TimescaleDB uses a built-in job scheduler to convert this data to the form of compressed columns. This occurs across chunks of TimescaleDB hypertables.

Keywords

compressionhypertables

Found an issue on this page?Report an issue or Edit this page in GitHub.

PreviousTroubleshoot TigerData productsNextAbout compression

Related Content

Troubleshooting backlog
Suggestions for troubleshooting common problems in backlog
Troubleshooting hypercore
Suggestions for troubleshooting common problems in hypercore
Troubleshooting columnstore
Suggestions for troubleshooting common problems in columnstore
Schema modifications
TimescaleDB enables you to modify the schema of compressed hypertables. This includes adding a nullable column, renaming and dropping a column, and adding a column with a default value
Troubleshooting compression
Suggestions for troubleshooting common problems in compression
Troubleshooting hypertables
Suggestions for troubleshooting common problems in hypertables