Every story and comment from the Hacker News API, in a layout borrowed from 2001.
A comment on Multi-node TimescaleDB is now free. Parent comment
compress_chunk operates on a single chunk, the way to define "compress all chunks older than 1 week is":
SELECT compress_chunk(i) from show_chunks('conditions', older_than => INTERVAL '1 week');
So you'd need to setup a cron job that runs that script every night or something...at least until we release compression policy support.
There are no comments on this comment yet.
compress_chunk operates on a single chunk, the way to define "compress all chunks older than 1 week is":
https://docs.timescale.com/latest/using-timescaledb/compress...So you'd need to setup a cron job that runs that script every night or something...at least until we release compression policy support.