Data Compression
Last updated
Last updated
Storing time series in PostgreSQL can be very demanding in terms of disk space consumption. For example, 500 time series changing every 500 ms will consume ~6000 MB of disk space per day. TimescaleDB provides a mechanism for automatically compressing data with a very high compression rate, for example, for the above case the size of compressed data will be ~350 MB. The store does not provide an automatic mechanism to set compression, but you can set it by running the following SQL scripts:
and
You can read more about data compression in TimescaleDB .