tl;dr This article shows you how to efficiently alter column data-types that leverages PostgreSQL TimeScale hyper-tables. Driving home from a long day of work, I see the beautiful sky and so I pull over to the side of the road to snap this picture. What a glorious sunset! But then you get back into your car and reality kicks in! :-) I was once again reminded of today’s challenges.