Stack Exchange network consists of 183 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
I've just upgraded from 1.4 to 1.6 and from what I understand, compression came in with 1.5. Will the mere upgrade of timescale, compress all my old data? I'm sitting with a space issue right now, and I'm actually wondering if I can move timescale chunks with ALTER TABLE table_partition SET TABLESPACE newtbsp; as mentioned above, instead of move_chunk. We're running community edition. Is this safe to do, or should I wait for the compression to kick in? The database is several hundred GB in size at this point.
@MichaelRazum I would love to know if you had success with moving timescale chunks to a new tablespace in this manner? We have some space issues now, and I want to move some data around until I can sort out an archiving process in a week or two.
