#TimescaleTuesday - Modifying Schemas of Compressed Hypertables in TimescaleDB 2.1

In this #TimescaleTuesday video, Developer Advocate @ryanbooz demonstrates a new enhancement in TimescaleDB 2.1 that allows users to modify the schema of a compressed Hypertable. In previous versions of TimescaleDB, modifying the schema of a compressed hypertable required a lot of extra work that involved uncompressing all chunks, disabling compression, modifying the schema and then compressing everything again. For many users, this wasn't an acceptable limitation and so compression wasn't utilized.

With TimescaleDB 2.1, users can now freely add and rename columns, allowing them to use compression early in a project without being concerned that they will be locked into a specific schema.

🛠 𝗥𝗲𝗹𝗲𝘃𝗮𝗻𝘁 𝗥𝗲𝘀𝗼𝘂𝗿𝗰𝗲𝘀

🐯 𝗔𝗯𝗼𝘂𝘁 𝗧𝗶𝗺𝗲𝘀𝗰𝗮𝗹𝗲
At Timescale, we are dedicated to serving developers worldwide, enabling them to build exceptional data-driven products that measure everything that matters. Analyzing this data across the time dimension ("time-series data") enables developers to understand what is happening right now, how that is changing, and why that is changing. We are backed by top-tier investors with a track record of success in the industry.

💻 𝗙𝗶𝗻𝗱 𝗨𝘀 𝗢𝗻𝗹𝗶𝗻𝗲!

#PostgreSQL​ #Database​ #Compression #Hypertables #Timeseries