A solution to store more data in smaller disks. Achieve +90% compression rates and get millisecond performance for your analytical queries—even when your tables reach billions of rows.
From the , Software Architect at
Timescale compression achieves unparalleled compression rates in PostgreSQL by combining an innovative columnar compression design with type-specific compression algorithms. Experience compression rates of +90% and immediately shrink your PostgreSQL storage requirements.
Thanks to its columnar storage design, Timescale compression improves the speed of your analytical queries looking at aggregated values (deep-and-narrow). They’ll stay at milliseconds even when looking at billions of rows.
-- Show max value for specified time frame
SELECT max(fare_amount)
FROM demo.yellow_compressed_ht
WHERE
tpep_pickup_datetime >= ‘2019-09-01’ AND
tpep_pickup_datetime <= ‘2019-09-01’;
max
---------
150998.39
(1 row)
-- Time before compression: 4.7 s
-- Time after compression: 77.1 ms
Leverage Tiered Storage in the Timescale platform to increase your storage savings the more your data grows. Once your data becomes older and infrequently accessed, tier it to our low-cost storage built on S3 and keep all your historical data in your database for a fraction of the cost.
1
2
3
4
For an example of what this looks like in action, check out our docs page on how energy companies set up their time-series database.
First 30 days are free, no credit card required.