News for hackers. Stuff that matters.
Re:Multi-node TimescaleDB is now free by jakaroo on Friday May 22, 2020 @02:08PM (#23275110)
Sounds great. So I just manually execute this `compress_chunks` command once on each data node and then I have compression enabled forever on those nodes?
Re:Multi-node TimescaleDB is now free by mfreed on Friday May 22, 2020 @02:50PM (#23275533)
Not yet, I should have been clearer:

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'); 
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.