Changing your huge table's data types in production [#FOSDEM 2021] #PostgreSQL devroom #postgres
Channel: Jimmy Angelakos
Date: 16/02/2021

You have a huge table, and it is necessary to change a column's data type, but your database has to keep running with no downtime. What do you do?  
Here's one way to perform this change, in as unobtrusive a manner as possible while your table keeps serving users, by avoiding long DDL table locks and leveraging procedural transaction control.

Talk from the PostgreSQL devroom at FOSDEM 2021

Slides: https://www.slideshare.net/vyruss000/changing-your-huge-tables-data-types-in-production